7 Replies Latest reply: Oct 12, 2015 3:49 AM by Tresesco B RSS

    Rolling 12 months average in chart

    Guohao Yee

      Hi All,


      I have the following set expression for rolling 12 months total:


      Sum({$<[Period]={'>=$(=Monthstart(Max(Period),-11))'}>} [Sales])


      It works fine in a KPI box. It returns the sum of the past 12 months with the largest value of [Period] as the start.


      However, when i use the same expression in a chart, only the sales for each month is plotted.


      What I am looking for is for the chart to show the rolling 12 months total for each data point.


      Please kindly advise what am I missing.