https://community.qlik.com/t5/App-Development/Qlikview-Pivot-table-Cumulative-Sum-for-the-year-selected/m-p/2109695#M90628 <P>I have a pivot table with running totals by month and year and Type and Sub Type dimensions.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gq_0-1692912027379.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115142i863488A3ACA37C31/image-size/medium?v=v2&amp;px=400" role="button" title="gq_0-1692912027379.png" alt="gq_0-1692912027379.png" /></span></P> <P>Since it has two many months to scroll from 2020 to 2024.&nbsp;</P> <P>I would like to have cumulative sum for the year selected starting from 2020.</P> <P>For example if 2020 is selected: It should show cumulative sum for 2020 by month and other dimensions.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; If 2021 is selected: cumulative sum of 2020 and 2021</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; If 2022 is selected: cumulative sum of 2020, 2021 and 2022 and so on</P> <P>Let me know if this possible.</P> <P>Thanks in Advance!</P> Fri, 15 Nov 2024 21:27:26 GMT gq 2024-11-15T21:27:26Z https://community.qlik.com/t5/App-Development/Qlikview-Pivot-table-Cumulative-Sum-for-the-year-selected/m-p/2109695#M90628 <P>I have a pivot table with running totals by month and year and Type and Sub Type dimensions.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gq_0-1692912027379.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115142i863488A3ACA37C31/image-size/medium?v=v2&amp;px=400" role="button" title="gq_0-1692912027379.png" alt="gq_0-1692912027379.png" /></span></P> <P>Since it has two many months to scroll from 2020 to 2024.&nbsp;</P> <P>I would like to have cumulative sum for the year selected starting from 2020.</P> <P>For example if 2020 is selected: It should show cumulative sum for 2020 by month and other dimensions.</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; If 2021 is selected: cumulative sum of 2020 and 2021</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; If 2022 is selected: cumulative sum of 2020, 2021 and 2022 and so on</P> <P>Let me know if this possible.</P> <P>Thanks in Advance!</P> Fri, 15 Nov 2024 21:27:26 GMT https://community.qlik.com/t5/App-Development/Qlikview-Pivot-table-Cumulative-Sum-for-the-year-selected/m-p/2109695#M90628 gq 2024-11-15T21:27:26Z