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.

       

      Thanks!