Pivot table column dates, reference column's date in expression

[rlawton1]

I have a pivot table with a valuelist as the dimension and years and months as the columns. In my values i display lots of figures, but for one of the values i want to display a rolling 3 month average. so i need to get the values for the 3 months preceding the current column month.

How would i do this? Is there a way to reference the month of the column in the expression?

[rlawton1 · Accepted solution]

I found the answer myself. By using the 'before()' function with an offset of 1, 2,3 for each prior month i wanted to access,