planner1234567
New Member
- Joined
- Oct 16, 2016
- Messages
- 1
Hi all,
Hoping someone can help me with an issue I'm having with pivot tables. I have an example below. I have a pivot table with two columns that are "Show values as...% of column total". I'd like to find the difference between those two columns without having to do a calculation outside of the pivot table. Is there anyway I can do this within the pivot table?
E.g in column F, the difference between d4 and e4 would be -1%.
Any idea??
Thank you in advance.
Hoping someone can help me with an issue I'm having with pivot tables. I have an example below. I have a pivot table with two columns that are "Show values as...% of column total". I'd like to find the difference between those two columns without having to do a calculation outside of the pivot table. Is there anyway I can do this within the pivot table?
E.g in column F, the difference between d4 and e4 would be -1%.
Any idea??
Thank you in advance.