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

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