Excel Pivot Table - Show % only for the Grand Total column

[msharkar]

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.

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>

 

[sheetspread]

If you're posting the total and % of total in the same table, I don't think one type of sales per region can be removed, just hidden. Instead you can put the second sum in another pivot table next to your first, and that way only have to hide 1 column rather than 4.

 

[msharkar]

If you're posting the total and % of total in the same table, I don't think one type of sales per region can be removed, just hidden. Instead you can put the second sum in another pivot table next to your first, and that way only have to hide 1 column rather than 4.

Thank you Mr. Excel - You made my life easy!