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