Qliksense- Cumulative total in a pivot table

[david145]

hi, 

i have a pivot table thats dimension = area, column = week and my measure = 

count(distinct [NeededID]) - count(distinct [%RequestID])

this gives me my weekly difference per area.

i need another pivot table that now shows me the Cumulative total. 

so it takes the current week total(the above measure) and adds the previous Cumulative weeks total = Cumulative weekly total.

is this possible? do i need to use the peek function somehow?

[MayilVahanan]

Hi

Try like below

rangesum(above(urexpression, 0, rowno(Total)))

or

rangesum(above(total urexpression, 0, rowno(Total)))