Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rlawton1
Contributor III
Contributor III

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

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?

 

Labels (2)
1 Solution

Accepted Solutions
rlawton1
Contributor III
Contributor III
Author

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,

View solution in original post

1 Reply
rlawton1
Contributor III
Contributor III
Author

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,