You can right-click on a subtotal, and remove the check mark from
Subtotal<fieldname

Or, to hide all the subtotals:
On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Subtotals
Choose Do Not Show Subtotals

Aurelio wrote:
In Excel 2003, you right-click a subtotal line that you don't want to have
displayed. You then click "Hide." Poof. All subtotals for that row heading
disappear from the whole pivot table.

Where has this feature gone in Excel 2007? I can't find it anywhere.
Thanks. --Au


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html