Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
gq
Contributor II
Contributor II

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