1 Reply Latest reply: Aug 13, 2017 2:35 AM by Kaushik Solanki RSS

    Creating rolling 12 value depending on month

    Mikael Hyensjo

      Hi

      I have a graph with monthly values (last 24 month - working fine) and rolling 12 values (picture 1) and its OK when no selection of month. But when I select a month the rolling values only shows on the selected month (picture 2). I would like to present the rolling 12 to the selected month and then 12 month back.


      and if possible show the data for a 24 month period as the monthly value

       

      Today I use the following syntax with :

      sum( aggr( rangesum( above( sum( {$<[YearMonth]>}  Revenue),0,12) ),[YearMonth]))