Microsoft Office Tutorials and References
In Depth Information
Data Analysis with Pivot Tables
Figure 9-4:
Indicate
the data
source and
pivot table
location in
the Create
PivotTable
dialog box.
After you indicate the source and location for the new pivot table in the
Create PivotTable dialog box and click OK, the program inserts a new
worksheet at the front of the workbook with a blank grid for the new pivot
table. It also opens a PivotTable Field List task pane on the right side of the
Worksheet area and adds the PivotTable Tools contextual tab to the Ribbon
(see Figure 9-5). The PivotTable Field List task pane is divided into two areas:
the Choose Fields to Add to Report list box with the names of all the fields
in the data list you can select as the source of the table preceded by empty
check boxes, and a Drag Fields between Areas Below section divided into
four drop zones (Report Filter, Column Labels, Row Labels, and Values).
Figure 9-5:
Completed
pivot table
after adding
the fields
from the
employee
data list to
the various
drop zones.
Search JabSto ::




Custom Search