Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to calculate progressive total of total rows

Hi everybody ,

i have i pivot table and i have  to calculate the progressive total of rows's total

I post an example so you  can understand better wath i want

Thanks in advance

2 Replies
Not applicable
Author

Try something like this into a new column

rangesum(above( total ( sum( Sales)),0,NoOfRows(TOTAL )))

Anonymous
Not applicable
Author

Thank mauretto for your reply,

the formula works and give the right result ...., the problem is  the sum is not display in the right row ,  i mean not display in rows of totals but in detail row...

How can display in the total row?

Thank