https://community.qlik.com/t5/QlikView/Pivot-table-make-Sum-current-month-12/m-p/1852963#M1215741 <P>I have a pivot table (image), as dimensions I have YEAR, MONTH, company name, pdr. As an Expression I have Sum (CONSUMO_SMC)<BR />I would need by selecting the years 2021 and 2020 that this table would show me the Sum (CONSUMO_SMC) from the current month to the current month -12 is it possible?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1Qlik.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/65467i191E86BEBA3E4E4E/image-size/large?v=v2&amp;px=999" role="button" title="1Qlik.jpg" alt="1Qlik.jpg" /></span></P> <P>.. and i add: I would also like to have in the last column, after the Grand total, the total number of MONTHS that have a value&gt; 0</P> Thu, 28 Oct 2021 09:54:26 GMT danosoft 2021-10-28T09:54:26Z https://community.qlik.com/t5/QlikView/Pivot-table-make-Sum-current-month-12/m-p/1852963#M1215741 <P>I have a pivot table (image), as dimensions I have YEAR, MONTH, company name, pdr. As an Expression I have Sum (CONSUMO_SMC)<BR />I would need by selecting the years 2021 and 2020 that this table would show me the Sum (CONSUMO_SMC) from the current month to the current month -12 is it possible?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1Qlik.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/65467i191E86BEBA3E4E4E/image-size/large?v=v2&amp;px=999" role="button" title="1Qlik.jpg" alt="1Qlik.jpg" /></span></P> <P>.. and i add: I would also like to have in the last column, after the Grand total, the total number of MONTHS that have a value&gt; 0</P> Thu, 28 Oct 2021 09:54:26 GMT https://community.qlik.com/t5/QlikView/Pivot-table-make-Sum-current-month-12/m-p/1852963#M1215741 danosoft 2021-10-28T09:54:26Z