Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
Sum({<YearQuarter, YoY, Year, Date1 = {"$(='>' & Date(AddYears(Max(Date1), -1), 'D/M/YYYY') & '<=' & Date(Max(Date1), 'D/M/YYYY'))"}>} Salary)