Pivot Tables
 

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.

Pivot Tables
 

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.

Pivot Tables
 

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

TFT

"Jacob Skaria" wrote:

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.