5 Replies Latest reply: Jun 16, 2014 4:04 PM by Goutham Kandukuri RSS

    Running total/Cumulative in pivot Chart

    Goutham Kandukuri

      Test.PNG.pngHI,

       

      I am trying to get cumulative total for net column, My calculation in (In - Out) + Previous Net(Running total) for each group.

      I tried using Range sum and above functions, getting only the value of previous row but not as a cumulative/ running total.

      If used in a straight table, by selecting Full Accumulation, i could achieve it.  But my scenario is to use a pivot table.

       

      Request for assistance.