This content has been marked as final. Show 8 replies
I have a pivot table with two Rows dimensions and Month-Year as column dimension.
I need the formula avg(score) in expression will display the result of rolling three month for each month.
Means for January 2018 it should show result for Nov 17, Dec 17 and Jan 18.
I red about rengesum and rangeaverage but it seems working in straight table but not pivot.
Any thoughts please?