# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for
Did you mean:
Creator III

## How to do cumulative number in qliksense pivot table ?

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 -

1 Solution

Accepted Solutions
MVP

Try this

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

May be this

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

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 ?

MVP

Try this

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

Thank you .