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

    Pivot table sum before

    Hans Müller

      Hi,

       

      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!