Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Hide Pivot Table Divide by 0 error | Excel Worksheet Functions |