Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative Values in a pivot table

I have a simple pivot table and I want it to show all cumulative values for each year.

See attached example.

Would appreciate some help.

Thanks

3 Replies
Not applicable
Author

I think you are getting total by year, Not sure what you are looking for.

Please see attached.

Not applicable
Author

What I want to see is the value in the months to accumulate down each column in the table so that the *** value for dec in each year is the same as all the months in the year added together.

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

The answer is:

=

sum(Value)+

If(Not IsNull(Above(sum(Value))),Above(sum(Value)),0)