Microsoft Office Tutorials and References
In Depth Information
Customizing Your Pivot Table
Did you know that a single blank cell causes Excel to count instead of sum? That’s right.
If all the cells in a column contain numeric data, Excel chooses Sum. If just one cell is
either blank or contains text, Excel chooses Count. Be sure to pay attention to the fields
that you place into the Values area of the pivot table. If the field name starts with Count
Of, Excel’s counting the items in the field instead of summing the values.
Notice that each time you add a field to your pivot table, Excel adds a subtotal for that field. There
may be, however, times when the inclusion of subtotals either doesn’t make sense or just hinders a
clear view of your pivot table report. For example, Figure 14-21 shows a pivot table where the
subtotals inundate the report with totals that serve only to hide the real data you’re trying to report.
Figure 14-21: Subtotals sometimes muddle the data you’re trying to show.
Removing all subtotals at one time
You can remove all subtotals at once by performing these steps:
1. To activate the PivotTable Tools context tab on the Ribbon, click anywhere inside your pivot
2. Click the Design tab.
3. Select the Subtotals icon and select Do Not Show Subtotals (see Figure 14-22).