Hello!
I understand the process of creating a pivot table to show the difference year over year in total sales by Account, but I'm wondering if there's a way to get the year totals to show alongside the differences.
Currently, my pivot table ends up looking like the below:
Account 2016 2017 Total Total Amount
First Account -5000
Second Account 7500
Third Account 6000
To get this, I dropped Year into columns, Account Name into rows, and Total Amount with the sum -> difference from function run on the Year.
What I'm looking to achieve is something like the below:
Account 2016 2017 Difference
First Account 10000 5000 -5000
Second Account 5000 12500 7500
Third Account 8000 14000 6000
Is there any suggested approach to achieving a view such as thing?
Thank you!