PDA

View Full Version : Pivot Table: pct by rows



fb7894
09-16-2016, 08:11 AM
I have a pivot table summing Green/Yellow/Red rows. Looks like this.


Row Labels
Sum of Green
Sum of Yellow
Sum of Red


Bear
27
1
10


Wolf
3
1
2


Grand Total
30
2
12




I need to express these as pct of ROW total. I cannot figure this out. here is what i need it to look like:


Row Labels
Sum of Green
Sum of Yellow
Sum of Red


Bear
71%
3%
26%


Wolf
50%
17%
33%


Grand Total
68%
5%
27%