Auto summing with Pivot Table

  • Thread starter Thread starter SPenney
  • Start date Start date
S

SPenney

I'm using a pivot table to summarize some shipping information by zi
code. At the end of each zip code section, the table automaticall
inserts a summary for that whole section. Is there a way to get rid o
this summary? Thanks.

Staci
 
Right click in the pivot table and select table options, uncheck Grand
Totals for Columns or Grand Totals for Rows (or both)
 
In the PivotTable, double-click on the zip code field button.
Under Summary, choose None
Click OK
 
Back
Top