Pivot Tables

[JSA]

Is there a way to automatically remove the automatic total field when adding
new fields into a pivot table? I know about right clicking and clearing the
field settings manually, but this can be tedious with multiple fields.

 

[Jacob Skaria]

Right click>Table Options>Under 'Format Options' uncheck

'Grand total for columns'
OR
'Grand total for rows'

If this post helps click Yes

 

[TroyT]

When you drag the Fields in you can simply right click(where it says Total)
and Hide form the popup window.

TFT