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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
gq
Contributor III
Contributor III

Qlikview: Pivot table Cumulative Sum for the year selected

I have a pivot table with running totals by month and year and Type and Sub Type dimensions.

 

gq_0-1692912027379.png

Since it has two many months to scroll from 2020 to 2024. 

I would like to have cumulative sum for the year selected starting from 2020.

For example if 2020 is selected: It should show cumulative sum for 2020 by month and other dimensions.

                        If 2021 is selected: cumulative sum of 2020 and 2021

                        If 2022 is selected: cumulative sum of 2020, 2021 and 2022 and so on

Let me know if this possible.

Thanks in Advance!

Labels (1)
0 Replies