Re: Cumulative total in a pivot table does not car... - Qlik Community

orangebloss · ‎2024-05-14

I need a cumulative count of the following data:

at the moment I've created a field called 'Count' populated with '1' in the data load and attempted a range sum

Rangesum(Before(Sum(Count),0,ColumnNo()))

which produces the following

I want it to show like this :

Is there a way to do this - either with the formula I have or an alternative approach?

hic · ‎2024-05-14

Try

Rangesum(Before(Sum(Count)+Sum({1} 0),0,ColumnNo()))

orangebloss · ‎2024-05-14

Thanks for that - I tried it but it just returned 0 for everything?

hic · ‎2024-05-14

Strange... That should work if you have the field "Yearweek" in a master calendar with all weeks defined.

orangebloss · ‎2024-05-15

Ah Yearweek is a field not a master calendar 😞

Cumulative total in a pivot table does not carry over