Set Analysis For Rolling periods in a dimension

[Anonymous]

Hi All,

I am struck with the below Problem.

Actually, When I select for a value(for suppose 2018Q1) I need to display only 4 trailing periods in the chart for that corresponding "YearQuarter" value. Means only 4 previous rows(2017Q1,2017Q2,2017Q3 and 2017Q4).

Dynamic Filtering here I need.

I have tried dual function(YOY) to filter the values, but couldn't achieve it.

Thank you in Advance!

-Suryakiran

[sunny_talwar]

May be like this

Sum({<YearQuarter, YoY, Year, Date1 = {"$(='>' & Date(AddYears(Max(Date1), -1), 'D/M/YYYY') & '<=' & Date(Max(Date1), 'D/M/YYYY'))"}>} Salary)