Learn How To Suppress Totals In A Pivot Table With This Microsoft Excel Tutorial

Learn How To Suppress Totals In A Pivot Table With This Microsoft Excel Tutorial
Page content

Strategy: You can turn off subtotals for any field.

  1. Double-click the Date field. Change the Subtotals setting from Automatic to None, as shown in Fig. 960.

  2. Double-click the Region field. Change the Subtotals from Automatic to None, as shown in Fig. 961.

Result: As shown in Fig. 962, every row in the pivot table is now a data point. If you copy and paste this table to a new workbook, you will not have to manually delete all the total rows.

Summary: When you have more than one Row field, you can remove the automatic subtotals on the outer fields in order to produce a cleaner looking report.

Commands Discussed: Data – PivotTables – Subtotals

Images

Fig. 960

Fig. 961

Fig. 962