https://community.qlik.com/t5/QlikView/Show-total-in-pivot-table/m-p/1573465#M442339 <P>Create an expression in your chart and use this syntax to get the difference between current and previous year per dimension:</P><PRE>Amount-After(Amount)</PRE> Thu, 25 Apr 2019 18:13:07 GMT pedromsouza 2019-04-25T18:13:07Z https://community.qlik.com/t5/QlikView/Show-total-in-pivot-table/m-p/1573169#M442321 <P>Hi all,</P><P>hope anyone can help me out on this one. Attached is a document with a pivot table. What do i have to do to add one column with the difference between the two years?</P><P>&nbsp;</P><P>Thank you in advance.</P><P>&nbsp;</P><P>Bart</P> Sat, 16 Nov 2024 03:45:50 GMT https://community.qlik.com/t5/QlikView/Show-total-in-pivot-table/m-p/1573169#M442321 bartvanwetten 2024-11-16T03:45:50Z https://community.qlik.com/t5/QlikView/Show-total-in-pivot-table/m-p/1573465#M442339 <P>Create an expression in your chart and use this syntax to get the difference between current and previous year per dimension:</P><PRE>Amount-After(Amount)</PRE> Thu, 25 Apr 2019 18:13:07 GMT https://community.qlik.com/t5/QlikView/Show-total-in-pivot-table/m-p/1573465#M442339 pedromsouza 2019-04-25T18:13:07Z