1 Reply Latest reply: Feb 23, 2018 12:39 PM by Sunny Talwar RSS

    Set Analysis For Rolling periods in a dimension

    Suryakiran Gunda

      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.

       

      dual.PNG

       

      Thank you in Advance!

       

      -Suryakiran