How to do cumulative number in qliksense pivot table ?

[suvechha_b]

Hi All ,

Please kindly assist me to get the cumulative number for the below table .

How to get the cumulative value - R1,621,456

                                                                      R1,621,456 +  R9,372,516

                                                                      R1,621,456 +  R9,372,516 + 6,899,589 and so on

Cumulative value like the arrow shows from below to top -

[sunny_talwar]

May be this

Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), [UW Month], ([Claims Payment Month], (NUMERIC)))

[suvechha_b]

Hi Sunny ,

It works, but the total is not working . Please see the image below -

Total should be = R10,993,972 + R 2,391,220 ?

[sunny_talwar · Accepted solution]

Try this

Sum(
Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), [UW Month], ([Claims Payment Month], (NUMERIC)))
)

[suvechha_b]

Thank you .