pliskers
Active Member
- Joined
- Sep 26, 2002
- Messages
- 447
- Office Version
-
- 2016
- Platform
-
- Windows
If I have two columns in a pivot table, each reflecting respective share of total numbers (this year vs last year), is there a way to calculate within the pivot table the difference between the two share columns? If I construct a formula to calculate the difference between the two, it bases the difference on the underlying values, not the share numbers.
Thanks, Excel masters!
Thanks, Excel masters!