I want to see total amounts in two years, and I want to see the difference.
In my pivot table I am trying to get the difference. But I always get it in year 2020.
What I want: I want to see amount for year 2019 and amount 2020, but in Grand total I want to get the difference from these two years.
In attachment I have sample of job 1, but of course I have also job 2, job 3 etc.
I want to get
400 millions for year 2019
504 millions for year 2020
and 104 in difference.
What I get is only 104millions in 2020 (the difference), if I try to use difference in my grand total.
I am doing this in powerpivot. I was not sure, maybe I should put this thread to powerpivot.