Hi Mr. Excel,
I've created a pivot table using the data from the table below. In the pivot table, I've added the percentage columns that included for all regions and grand total. However, I want to see % column for grand total only. Is there any way I can remove the % columns for the regions (other than hiding them) and keep the % column for grand total in the pivot table.
Your reply will be highly appreciated!
Thanks.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I've created a pivot table using the data from the table below. In the pivot table, I've added the percentage columns that included for all regions and grand total. However, I want to see % column for grand total only. Is there any way I can remove the % columns for the regions (other than hiding them) and keep the % column for grand total in the pivot table.
Your reply will be highly appreciated!
Thanks.
Sales Person | Region | Sales |
A | NORTH | 10 |
B | SOUTH | 20 |
C | EAST | 30 |
D | WEST | 15 |
E | SOUTH | 20 |
F | EAST | 30 |
G | WEST | 15 |
H | NORTH | 30 |
A | SOUTH | 15 |
B | EAST | 20 |
C | WEST | 30 |
D | NORTH | 15 |
E | EAST | 20 |
F | WEST | 30 |
G | NORTH | 15 |
H | SOUTH | 30 |
A | EAST | 15 |
B | SOUTH | 20 |
C | EAST | 30 |
D | WEST | 15 |
E | NORTH | 20 |
F | EAST | 30 |
G | WEST | 15 |
H | SOUTH | 30 |
A | EAST | 15 |
B | WEST | 20 |
C | SOUTH | 30 |
D | EAST | 15 |
E | EAST | 20 |
F | SOUTH | 30 |
G | EAST | 15 |
H | WEST | 30 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Column Labels | ||||||||||
EAST | NORTH | SOUTH | WEST | Total Sum of Sales | Total Sum of Sales2 | |||||
Row Labels | Sum of Sales | Sum of Sales2 | Sum of Sales | Sum of Sales2 | Sum of Sales | Sum of Sales2 | Sum of Sales | Sum of Sales2 | ||
A | 30 | 13% | 10 | 11% | 15 | 8% | 0 | 0% | 55 | 8% |
B | 20 | 8% | 0 | 0% | 40 | 21% | 20 | 12% | 80 | 12% |
C | 60 | 25% | 0 | 0% | 30 | 15% | 30 | 18% | 120 | 17% |
D | 15 | 6% | 15 | 17% | 0 | 0% | 30 | 18% | 60 | 9% |
E | 40 | 17% | 20 | 22% | 20 | 10% | 0 | 0% | 80 | 12% |
F | 60 | 25% | 0 | 0% | 30 | 15% | 30 | 18% | 120 | 17% |
G | 15 | 6% | 15 | 17% | 0 | 0% | 30 | 18% | 60 | 9% |
H | 0 | 0% | 30 | 33% | 60 | 31% | 30 | 18% | 120 | 17% |
Grand Total | 240 | 100% | 90 | 100% | 195 | 100% | 170 | 100% | 695 | 100% |
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>