Microsoft Office Tutorials and References
In Depth Information
Customizing Your Pivot Table
Figure 14-22: Use the Do Not Show Subtotals option to remove all subtotals at once.
As you can see in Figure 14-23, the same report without subtotals is much more pleasant to review.
Figure 14-23: The same report without subtotals.
Removing the subtotals for only one field
Maybe you want to remove the subtotals for only one field? In such a case, you can perform the
1. Right-click any value within the target field.
2. To display the Field Settings dialog box, select Field Settings.
3. Select None under the Subtotals options (see Figure 14-24).
4. Click OK.