Skip to Content
Apr 09, 2018 at 09:06 AM

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

3591 Views Last edit Apr 09, 2018 at 05:04 AM 2 rev

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!