3 Replies Latest reply: Sep 29, 2015 10:14 AM by Hans Müller RSS

    Pivot table sum before



      I have following problem. I created a pivo table with a sum formula and an additional formual sum before for making a comparison. But the formula at the moment will be executed for every column. But I want that this sum before forumal should only executed for the dimension run.


      The result should like this


      Run: 1 -> sum(Amount) = 350; before(sum(Amount) = -

      Run: 2 -> sum(Amount) = 175; before(sum(Amount) = - 175

      Run: 3 -> sum(Amount) = 215; before(sum(Amount) = + 40


      The column for before(sum) should based on the right right side for every Run.

      Please look at my app.


      Thank you!