#1
|
|||
|
|||
How do I get the percentage to work by group
Hi all
I have a pivot table with 4 groups of colors with size and amount. I want to get the percentage of each color by group. I tried to use the percent function but its only doing the grand total and not the sub-total of each group. Can anyone assist? I am attaching a sample for your review. Thanks in advance |
#2
|
||||
|
||||
Instead of show values as % of Grand Total, use either:
% of Parent Row total which will show the colour subtotals as percent of Grand Total still, or: % of Parent total and choose COLOR as the base field, which will show the subtotals as all 100%. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Percentage of . . . | chaserwill | Excel | 1 | 03-10-2017 09:28 AM |
Need forumla for percentage | mquillen | Excel | 5 | 02-06-2017 08:59 AM |
Group records - multiple IF stmts - Text After Group | baum12 | Mail Merge | 1 | 05-25-2015 12:57 AM |
Group Table Rows/Column (like Excel Group) | eoinymc | Word | 1 | 03-11-2014 04:51 AM |
overall percentage | ketanco | Project | 1 | 08-04-2012 05:56 AM |