Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this document: Calculating rolling n-period totals, averages or other aggregations
Or this blog post: The As-Of Table
hi how can i add last 2 expressions as i have month as dimension
Open the charts properties window, go to the Expressions tab and press the Add button to add a new expression.