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%
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%