Is it possible to change the grand total in a pivot table to be a difference of the columns vs a total? If I us the show value as option, I lose the data in the columns and I would like to keep that. Below is what I am trying to get to
Category | 2019 | 2020 | Delta |
Shoes | $ 10,000 | $ 150,000 | $ 140,000 |
Shirts | $ 157,845 | $ 252,111 | $ 94,266 |
Socks | $ 25,222 | $ 12,333 | $ (12,889) |
Jackets | $ 321,321 | $ 322,222 | $ 901 |