Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Eliminating Pivot Table Subtotals
I've created a pivot table and I want to eliminate the subtotal (I
don't want to hide all the subtotal rows). Any ideas? e.g. Jan Item 1 2002 1000 2003 1000 2004 1000 2005 1000 Item 1 subtotal 4000 <-- eliminate this |
#2
|
|||
|
|||
Double-click on the Item field button
For Subtotals, select None Click OK wrote: I've created a pivot table and I want to eliminate the subtotal (I don't want to hide all the subtotal rows). Any ideas? e.g. Jan Item 1 2002 1000 2003 1000 2004 1000 2005 1000 Item 1 subtotal 4000 <-- eliminate this -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Should be nothing more than double-clicking on the grey field name for that
item's category and selecting None for subtotals, yes? " wrote: I've created a pivot table and I want to eliminate the subtotal (I don't want to hide all the subtotal rows). Any ideas? e.g. Jan Item 1 2002 1000 2003 1000 2004 1000 2005 1000 Item 1 subtotal 4000 <-- eliminate this |
#4
|
|||
|
|||
Thanks Debra! Your awesome.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot table subtotals help needed | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table subtotals | Excel Worksheet Functions | |||
Pivot table. Calcualting % from subtotals. | Excel Worksheet Functions |