Part V: Analyzing Data with Excel
702
Click OK, and Excel creates an empty pivot table and displays its PivotTable Field List task pane,
as shown in Figure 34.8.FIGURE 34.8Use the PivotTable Field List to build the pivot table.
Tip
The PivotTable Field List is typically docked on the right side of the Excel window. Drag its title bar to move it
anywhere you like. Also, if you click a cell outside the pivot table, the PivotTable Field List is hidden. n
Laying out the pivot table
Next, set up the actual layout of the pivot table. You can do so by using either of any techniques:l (^) Drag the field names (at the top) to one of the four boxes at the bottom of the PivotTable
Field List.
l (^) Place a check mark next to the item at the top of the PivotTable Field List. Excel will place
the field into one of the four boxes at the bottom.
l (^) Right-click a field name at the top of the PivotTable Field List and choose its location from
the shortcut menu.