Eliminating Pivot Table Subtotals

[cailotto]

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]

Double-click on the Item field button
For Subtotals, select None
Click OK

 

[Guest]

Should be nothing more than double-clicking on the grey field name for that
item's category and selecting None for subtotals, yes?

 

[cailotto]

Thanks Debra! Your awesome.

 

[Debra Dalgleish]

You're welcome!

Thanks Debra! Your awesome.