Show total in pivot table

[bartvanwetten]

Hi all,

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?

Thank you in advance.

Bart

[pedromsouza]

Create an expression in your chart and use this syntax to get the difference between current and previous year per dimension:

Amount-After(Amount)