3 Replies Latest reply: Aug 13, 2013 7:49 AM by Gysbert Wassenaar RSS

    Rolling N Months Calculation

      Hello,

       

      I have a table like this:

       


      JanFebMarAprMay
      Amount120232302322382

       

      When I select Apr, the Pivot Table only shows:

       


      Apr
      Total = Sum(Amount)322

       

      How could I make Total to be sum of Feb's, Mar's and Apr's amount, i.e. rolling 3 months, and giving out 856, i.e. 232 + 302 + 322?

       

      Please help and advise. Thank you.