Microsoft Office Tutorials and References
In Depth Information
Creating a Pivot Table
Figure 18-8: Use the PivotTable Field List to build the pivot table.
Laying out the pivot table
Next, set up the actual layout of the pivot table. You can do so by using any of these techniques:
h Drag the field names to one of the four boxes at the bottom of the PivotTable Field List.
h Place a check mark next to the item. Excel places the field into one of the four boxes at
h Right-click a field name and select its location from the shortcut menu.
In versions prior to Excel 2007, you could drag items from the field list directly into the
appropriate area of the pivot table. This feature is still available, but it’s turned off by
default. To enable this feature, choose PivotTable Tools➜Options➜PivotTable➜
Options to display the PivotTable Options dialog box. Click the Display tab
and add a check mark next to Classic PivotTable Layout.