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
