Cumulative total in a pivot table does not carry o... - Qlik Community

orangebloss

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

Try

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

orangebloss

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

hic

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

orangebloss

Ah Yearweek is a field not a master calendar 😞

Cumulative total in a pivot table does not carry over