Part IV: Managing and Analyzing Data
FIGURE 30.17
The Insert Calculated Item dialog box
A calculated item, unlike a calculated field, does not appear in the PivotTable Fields task pane. Only fields appear in
the field list.
If you use a calculated item in your PivotTable, you may need to turn off the Grand Total display for columns to avoid
double counting. In this example, the Grand Total includes the calculated items, so the commission amounts are
included with the sales amounts. To turn off Grand Totals, choose PivotTable Tools Design ➪ Layout ➪ Grand Totals
➪ Off for Rows and Columns.
After you create the calculated items, they appear in the PivotTable. Figure 30.18 shows
the PivotTable after adding the four calculated items. Notice that the calculated items are
added to the end of the Month items. You can rearrange the items by selecting the cell and
dragging its border. Another option is to create two groups (manually): one for the sales
numbers and one for the commission calculations. Figure 30.19 shows the PivotTable after
creating the two groups and adding subtotals.
