4 Replies Latest reply: Apr 30, 2013 6:17 AM by thor.ostergaard RSS

    Cumulative sum in pivottable on month - including values before/outside

      Hi,

      Sorry if this already have an answer on the community - I was not able to find it...

       

      I have A pivottable like this

       

       

      Project
      2013-Mar2013-Apr
      2013-May
      2013-Jun
      2013-Jul
      P11020304050
      P22232334455

       

      And inside I would like to show the cumulative amount used on the project up till the month.

       

      I'm not able to use rangesum and above because I want to include all values before 2013-Mar in the sum.

       

      What to do?