1 Reply Latest reply: Jun 21, 2017 4:36 AM by Marwan Lakrari RSS

    Cumulative sum in a two-dimensional pivot table

    Marwan Lakrari

      Hello,

       

      Here is my pivot table :

      pivot.PNG

      There are two dimensions year (Année) and month (mois)  and I'm currently trying to calculate a cumulative sum for the column "Nbre total de OK".

       

      The cumulative sum is stored in the column "Nbre total de OK Cumul", as you can see I already tried something with this expression : rangesum(above( sum([Nbre total de OK]), 0, rowno())) .

       

      The problem is that it restarts the sum for each year, any idea how to just have the cumulative sum without restarting ?