When you insert a PivotTable or select an inserted PivotTable, the PivotTable Field task pane appears, showing all fields and area-specific configuration.
Here you can see the entire field and area-specific configuration of the PivotTable, and you can drag the fields to edit the configuration of the PivotTable.
Shows a list of all fields in the selected area. Drag the fields to each area at the bottom to form a PivotTable.
Checking the checkbox in fron of each field automatically fills in the area below to form a PivotTable.
This area places the field by which you want to base across the PivotTable and is used to filter the values in the data area.
Displays row information to the left of the PivotTable.
Displays column information to the left of the PivotTable.
This area displays the values that change according to the row and column information as a source list containing data.
The PivotTable Field task pane allows you to move a PivotTable in various ways.
In Select fields to add to the report, drag the items into the PivotTable area on the worksheet fills the field in that area. Also, dragging from Select fields to add to the report t
The PivotTable Field task pane allows you to move a PivotTable in various ways.
In Select fields to add to the report, drag the items into the PivotTable area on the worksheet fills the field in that area. Also, dragging from Select fields to add to the report to each of the area list boxes below populates the fileds in that area.
Fields that have already been entered can be moved to the location you want by clicking the expand menu.