https://community.qlik.com/t5/QlikView/Adding-summary-columns-in-pivot-table/m-p/1704944#M506148 <P>Thank you very much!</P> Mon, 25 May 2020 14:45:36 GMT smith180579 2020-05-25T14:45:36Z https://community.qlik.com/t5/QlikView/Adding-summary-columns-in-pivot-table/m-p/1704908#M506146 <P>Hi all.</P><P>I have an issue I do not know how to solve.</P><P>The pivot table that reflects the monthly sales for the current and previous year in the attachment&nbsp;.</P><P>Last two columns should be summary.</P><P>First summary column should reflect sales amount starting from the beginning of the current year till selected month of current year (e.g. jan,20-apr,20).<BR />Second summary column should reflect sales amount starting from the beginning of the previous year till selected month of previous year(e.g. jan,19-apr,19).</P><P>Thanks in advance!</P> Mon, 25 May 2020 12:04:17 GMT https://community.qlik.com/t5/QlikView/Adding-summary-columns-in-pivot-table/m-p/1704908#M506146 smith180579 2020-05-25T12:04:17Z https://community.qlik.com/t5/QlikView/Adding-summary-columns-in-pivot-table/m-p/1704920#M506147 <P>Hi, in presentation tab you can check the option to show partial sums on 'MY' dimension:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rubenmarin_0-1590413118608.png" style="width: 728px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34291iAE88588DBDDAEF1F/image-dimensions/728x70?v=v2" width="728" height="70" role="button" title="rubenmarin_0-1590413118608.png" alt="rubenmarin_0-1590413118608.png" /></span></P><P>&nbsp;</P> Mon, 25 May 2020 13:25:48 GMT https://community.qlik.com/t5/QlikView/Adding-summary-columns-in-pivot-table/m-p/1704920#M506147 rubenmarin 2020-05-25T13:25:48Z https://community.qlik.com/t5/QlikView/Adding-summary-columns-in-pivot-table/m-p/1704944#M506148 <P>Thank you very much!</P> Mon, 25 May 2020 14:45:36 GMT https://community.qlik.com/t5/QlikView/Adding-summary-columns-in-pivot-table/m-p/1704944#M506148 smith180579 2020-05-25T14:45:36Z