Pivot Tables

  • Thread starter Thread starter JSA
  • Start date Start date
J

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.
 
Right click>Table Options>Under 'Format Options' uncheck

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

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

TFT
 
Back
Top