-
Pivot Table: pct by rows
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%
|
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules