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%