Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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()))