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

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

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

Thanks Debra! Your awesome.

You're welcome!

wrote:
Thanks Debra! Your awesome.



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