Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Grand Total for Rows
I'm using XL 2002 and I have a pivot table that has "Grand totals for rows" turned on. This works perfect. However, amongst the rows of data, I have one row that is static...it simply shows the 'goal' for the respective column. I don't want that row to show anything in the Grand Total column. Is there a trick way to defeat the appearance of the Grand Total for just that row. Goal doesn't need to have any type of calculation performed on it...it's simply a reference number for the related dat in the its respective column that it appears in. Example: Item Q1 Q2 Q3 Q4 Grand Total West 10 20 30 40 100 South 15 25 35 45 120 Goal 5 5 5 5 <---- Have nothing appear here. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Grand Total for Rows
You can't turn off the Grand Total for specific items, but you could
format the cell with white font, which would hide it. Joe wrote: I'm using XL 2002 and I have a pivot table that has "Grand totals for rows" turned on. This works perfect. However, amongst the rows of data, I have one row that is static...it simply shows the 'goal' for the respective column. I don't want that row to show anything in the Grand Total column. Is there a trick way to defeat the appearance of the Grand Total for just that row. Goal doesn't need to have any type of calculation performed on it...it's simply a reference number for the related dat in the its respective column that it appears in. Example: Item Q1 Q2 Q3 Q4 Grand Total West 10 20 30 40 100 South 15 25 35 45 120 Goal 5 5 5 5 <---- Have nothing appear here. Any help would be greatly appreciated. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Grand Total for Rows
Thank you Debra for the quick reply. I thought about the white formatting
trick but how would you do it for an 'unknown' number of rows........or do I have to format them manually each time I refresh the pivot table ie: one day I may have 10 instances to format and then the next day I may have 35 instances to reformat. "Debra Dalgleish" wrote: You can't turn off the Grand Total for specific items, but you could format the cell with white font, which would hide it. Joe wrote: I'm using XL 2002 and I have a pivot table that has "Grand totals for rows" turned on. This works perfect. However, amongst the rows of data, I have one row that is static...it simply shows the 'goal' for the respective column. I don't want that row to show anything in the Grand Total column. Is there a trick way to defeat the appearance of the Grand Total for just that row. Goal doesn't need to have any type of calculation performed on it...it's simply a reference number for the related dat in the its respective column that it appears in. Example: Item Q1 Q2 Q3 Q4 Grand Total West 10 20 30 40 100 South 15 25 35 45 120 Goal 5 5 5 5 <---- Have nothing appear here. Any help would be greatly appreciated. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Grand Total for Rows
In your first post you said that it was "one row that is static", so
manual formatting might have worked in that situation. If it's a variable number of rows, you could apply formatting programmatically, or experiment with conditional formatting, based on the row and column headings. Joe wrote: Thank you Debra for the quick reply. I thought about the white formatting trick but how would you do it for an 'unknown' number of rows........or do I have to format them manually each time I refresh the pivot table ie: one day I may have 10 instances to format and then the next day I may have 35 instances to reformat. "Debra Dalgleish" wrote: You can't turn off the Grand Total for specific items, but you could format the cell with white font, which would hide it. Joe wrote: I'm using XL 2002 and I have a pivot table that has "Grand totals for rows" turned on. This works perfect. However, amongst the rows of data, I have one row that is static...it simply shows the 'goal' for the respective column. I don't want that row to show anything in the Grand Total column. Is there a trick way to defeat the appearance of the Grand Total for just that row. Goal doesn't need to have any type of calculation performed on it...it's simply a reference number for the related dat in the its respective column that it appears in. Example: Item Q1 Q2 Q3 Q4 Grand Total West 10 20 30 40 100 South 15 25 35 45 120 Goal 5 5 5 5 <---- Have nothing appear here. Any help would be greatly appreciated. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting of Pivot Table Field | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions |