Excel 2010 Bible

Part V: Analyzing Data with Excel

730

After you create the calculated items, they appear in the pivot table. Figure 35.18 shows the pivot

table 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: One for the sales numbers, and one for the commission

calculations. Figure 35.19 shows the pivot table after creating the two groups and adding subtotals.

FIGURE 35.18

This pivot table uses calculated items for quarterly totals.

FIGURE 35.19

The pivot table, after creating two groups and adding subtotals.