Globally deleted SubTotals in a PivotTable

[Joey]

I have created a PivotTable and each time I add a Row, it automatically adds
a SubTotal row. Is there somewhere that can I change this default globally
so I don't have to select each row and uncheck SubTotals.

 

[Jim Thomlinson]

So you have a field list with fields that you can add or remove from your
pivot table. If you add a field to the table it will automatically be added
with a aggregation such as sum or count. There is no way to turn this off.
That being said if your source data is set up correctly you should not have
more than a hand full of fields that need to be added to the table.

 

[Debra Dalgleish]

After you've created the pivot table, you could use a macro to turn all
the subtotals off. There's code to do that in the pivot table add-in,
that you can download here:

http://www.contextures.com/xlPivotAddIn.html

 

[Joey]

Debra- this is perfect! Thank you!

After you've created the pivot table, you could use a macro to turn all
the subtotals off. There's code to do that in the pivot table add-in,
that you can download here:

http://www.contextures.com/xlPivotAddIn.html