Microsoft Office Tutorials and References
In Depth Information
Chapter 26: Pivot Tables
FIGURE 26.3 Initial PivotTable Layout and Look
FIGURE 26.4 Activate the Classic Layout of the PivotTable
In our example, we will move the Gender field to the Row Labels area on the left
and the Job field to the Column Labels at the top. There are a few ways this can be
achieved. The easiest way with Excel 2010 or previous versions (in the classic layout)
is to drag and drop the fields. Drag the Gender field to the Row Field area on the left
of the table and the Job field to the Column Field area. See Figure 26.7.
Now drag the Age field to the center of the table (it reads
Drop Data Items
). See the result in Figure 26.8.
By default, the PivotTable calculates the sums of all values. For example, the sum
of all the ages of all the Female Carpenters is 67. The sum of the ages of all
Machinists is 85. The sum of the ages of all Males is 370.