Some data shouldn't summarize in pivot table

[ExcelAnt]

Hi,
I have a pivot table that displays a number of stock positions, sorted by Industry. For some of the data fields, I want subtotals, but for others, the subtotals would be meaningless and I'd like them not to display. For example (sorry about the imperfect formatting):

-----------------Units----Price----MarketValue
+Technology ___________________$800
MSFT___________10______20_____$200
AOL____________ 20______30_____$600

+OIL & GAS ___________________$3200
Etc.

Notice in the above, the Market Value sums up to a subtotal (technology=800), but I do not want totals to dispaly for units or price. Is there a way to implement this? For now I have set the text color manually to white to hide them, but this is unstable and I believe will break down as new subcategories appear on the chart.

Anybody have a good solution?

Thanks,
Ben

 

[ExcelAnt]

For anybody interested in a solution...

I found that excel 2007 Conditional Formatting works well with pivot tables. I believe previousl versions did not, but using a conditional formatting rule I was able to selectively set a custom number format to "" to hide fields depending on their summary-level.

Ben