Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tripatiqv
Partner - Contributor III
Partner - Contributor III

Need running total in pivot table in qlikview

Dear All,

Our requirement is We need running total in pivot table.

For Example On 5th of Jan we need sum of sales from 1st Jan to 4th Jan.

I have attached qlikview file and excel file.

 

Please check

Labels (2)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Does this expression suit your need?

=RangeSum(Above(Sum(Sales), 0, RowNo()))

 

View solution in original post

1 Reply
Vegar
MVP
MVP

Does this expression suit your need?

=RangeSum(Above(Sum(Sales), 0, RowNo()))