8 Replies Latest reply: Jan 25, 2018 3:24 PM by Denis LOMAKIN RSS

    Rolling N Month in Pivot Table

    Denis LOMAKIN

      Hi All,

      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?