I have a pivot table with running totals by month and year and Type and Sub Type dimensions.
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!