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

    Cumulative sum in a two-dimensional pivot table

    Marwan Lakrari



      Here is my pivot table :


      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 ?