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!