Skip to Content
0

How do I calculate Year to Date for Last year in SAP Analytics cloud with Bex Query as Data source?

Apr 09 at 09:06 AM

33

avatar image

Hello Guys,

Can someone help me on below scenario?

I am using Bex Query as a source.

We have Data for 2 years lets say 2017, 2018.

Current Year YTD will show data from Jan-Apr( Till Date) for current Year.

Last year YTD will Show data from Jan- Apr (Till date) for the Last Year.

In SAP Analytics cloud, for Current year YTD, we can use a dynamic filter option but there is no option like current year -1 to get YTD data for last year.

Thanks in Advance!

Regards

Rakesh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Apr 09 at 09:07 AM
1

Hello Rakesh - I would look at doing these types of calculations back in the BEx query first; performance will be faster that way

See https://blogs.sap.com/2012/10/29/define-ytdyear-to-date-logic-on-query-designer/ and https://archive.sap.com/discussions/thread/3520705

Share
10 |10000 characters needed characters left characters exceeded
Rakesh Kumar Apr 10 at 09:33 AM
0

Thanks a lot Tammy Powlas.

We are also following the same approach and trying to create YTD and MTD on the backend.

Share
10 |10000 characters needed characters left characters exceeded