Cumulative sum in a two-dimensional pivot table

Thu, 15 Jun 2017 08:36:03 GMT

Hello,

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 ?

Re: Cumulative sum in a two-dimensional pivot table

Wed, 21 Jun 2017 08:36:46 GMT

Here is the correct expression : RangeSum(Above(total sum([Nbre total de OK]), 0, RowNo(TOTAL)))

topic Re: Cumulative sum in a two-dimensional pivot table in QlikView

Cumulative sum in a two-dimensional pivot table

Re: Cumulative sum in a two-dimensional pivot table