Pivot Table Grand Totals - Hide Some, Not All
 

I have a pivot table I use to summarize my company's sales force performance.
The rows are data for each date. The columns are in groups of 4 which
include $, % of $ to daily total, quantity, and % of qty to daily total.
There are about 20 of these groups. All the way to the right, there are 4
grand total columns. I want to show the grand total $ and qty, but I would
like to hide the % to total columns because they have 100% in every row. Can
this be done? Thanks.

Click the letter of the column you want to hide to select the entire column,
then right click and select "hide".

"Pasko1" wrote:

I have a pivot table I use to summarize my company's sales force performance.
The rows are data for each date. The columns are in groups of 4 which
include $, % of $ to daily total, quantity, and % of qty to daily total.
There are about 20 of these groups. All the way to the right, there are 4
grand total columns. I want to show the grand total $ and qty, but I would
like to hide the % to total columns because they have 100% in every row. Can
this be done? Thanks.

You could change the font colour to white for that grand total. The
column will appear empty, and the results will stay hidden, even if you
pivot the data in the table.

Pasko1 wrote:
I have a pivot table I use to summarize my company's sales force performance.
The rows are data for each date. The columns are in groups of 4 which
include $, % of $ to daily total, quantity, and % of qty to daily total.
There are about 20 of these groups. All the way to the right, there are 4
grand total columns. I want to show the grand total $ and qty, but I would
like to hide the % to total columns because they have 100% in every row. Can
this be done? Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html