6 Replies Latest reply: Apr 27, 2017 7:57 AM by Sunny Talwar RSS

    Rolling Average for 3 months

    RAM MUTHIAH M

      I have month with year, sales. I want rolling 3 months sum. If I click only Dec 2012, it should show the previous 3 months rolling sum. I tried this expression, it doesn't work according to my requirement "sum( aggr( rangesum( above( sum(Sales),0,12) ),Month))". Can anybody help?

       

       

      error.png