7 Replies Latest reply: Jan 24, 2018 10:18 AM by Petter Skjolden RSS

    Accumulation - outer/inner dimension

    Martin Baculik

      Hello guys,

       

      very quick question. I would like to accumulate over inner dimension (Dim2). Without editing script.

       

      Current:

      Img.PNG

       

      Desired:

      accumulated sum(Exp) in Pivot table

      24.1.2018 P0 23.25

                       P1 12.25

                       P2 10.20

      "TOTAL"        45.70

      ...

      29.1.2018 P0 23.25

                       P1 12.25

                       P2 11.20

      "TOTAL"        46.70

      ...

      30.1.2018 P0 23.25

                       P1 13.25

                       P2 11.20

      "TOTAL"        47.70

      ...

      Thank you.

       

      BR

      Martin