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.




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


      Note i think this will only work in pivot tables