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

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. 959
Fig. 960
Fig. 961
Fig. 962