Pivot Table Grand Totals - Hide Some, Not All

G

Guest

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.
 
G

Guest

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

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grand Totals for Pivot Tables 4
Grand Total for Rows not Working in a Pivot Table 1
Pivot table grand total location 1
I can't see Grand total rows even though the option's switched on 2
Pivot Table - 3
Pivot Totals: Group totals different from Grand totals 1
Pivot Table Calculates the Difference in Grand Total 2
How do I perform extended calculations in a Pivot Table in Excel 2 4

Top