Right clickTable OptionsUnder 'Format Options' uncheck

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

If this post helps click Yes
---------------
Jacob Skaria


"JSA" wrote:

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.