Pivot Table: Turn Off Row Field Sub Totals ?

[lameid]

This is driving me nuts...

In the Excel UI is there a way to turn off the sub totals for multiple row fields at the same time in a Pivot table... I can write the macro to do it but I thought there has to be a way to do it in Excel. Am I wrong?

Thanks in advance.

 

[SkipVought]

Right click on the PivotField heading.

Select Field Settings: Subtotals NONE Option



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lameid]

Thanks Skip, but I wanted to turn off a selection of fields or all of them.

 

[SkipVought]

You have my pwemission.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}