1 Reply Latest reply: Aug 4, 2011 8:19 AM by Sunil Chauhan RSS

    3 month rolling average before and after

      Hi All

       

      IN a pivot table I have been trying to calculate a time series showing a 3 month rolling average that includes the month before and month after the current month eg for April i want the average to be for data in March, April and May. I could not find the answer on the community so thought i woudl put it up if others are having the same problem.

       

      Solution:

       

      =rangeavg(after($(varActivity),0,2), before($(varActivity),1,1)  )

       

      Note i think this will only work in pivot tables

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      thanks

      dan