Moving Month Average

[shruthibk]

Hi all,

i Need to find moving month average for latest 3 months,but my problem is i am using pivot table with 3 dimensions including monthyear i need to add average and deviation at the end ,please help me to achieve this

please find the sample requirement snapshot

Regards,

Shruthi

[Gysbert_Wassenaar]

See this document: Calculating rolling n-period totals, averages or other aggregations

Or this blog post: The As-Of Table

[shruthibk]

hi how can i add last 2 expressions as i have month as dimension

[Gysbert_Wassenaar]

Open the charts properties window, go to the Expressions tab and press the Add button to add a new expression.