3 month rolling average before and after

[#1]

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

[SunilChauhan]

please see the attached

replace fields

you will get the desired result