I have a Pivot Table with values:
Hats Shirts
Jan Feb Mar Total Jan Feb Mar Total Grand Total
25 30 45 100 40 65 70 175 275
Jan has 65 items with 25 hats and 40 shirts.
I want Jan Hats to show 38% (of the total Jan items) and Jan shirts to show 62% (of the total Jan items) for a total of 100%.
In the "show values as" option in the pivot table I've tried the % of row total, % of parent row total, etc. but can't get it to show the correct percentages.
How do I get the pivot table to show the percentages below????
Hats Shirts
Jan Feb Mar Total Jan Feb Mar Total Grand Total
38% 32% 39% 36% 62% 68% 61% 64% 100%
Thank you in advance.
Bookmarks