Microsoft Office Tutorials and References
In Depth Information
Chapter 14: Using Pivot Tables
Anatomy of a pivot table
A pivot table is composed of four areas: Values, Row Labels, Column Labels, and Filters. The data you
place in these areas defines both the use and presentation of the data in your pivot table. We now
discuss the function of each of these four areas.
The Values area allows you to calculate and count the source data. In Figure 14-1, it is the large
rectangular area below and to the right of the column and row headings. In this example, the Values area
contains a sum of the values in the Sales Amount field.
The data fields that you drag and drop here are typically those that you want to measure — fields,
such as the sum of revenue, a count of the units, or an average of the prices.
Figure 14-1: The Values area of a pivot table calculates and counts the data.
Row Labels area
The Row Labels area is shown in Figure 14-2. Dragging a data field into the Row Labels area displays
the unique values from that field down the rows of the left side of the pivot table. The Row Labels
area typically has at least one field, although it’s possible to have no fields.
The types of data fields that you drop here include those that you want to group and categorize,
such as products, names, and locations.
Column Labels area
The Column Labels area contains headings that stretch across the top of columns in the pivot table,
as you can see in Figure 14-3. In this example, the Column Labels area contains the list of unique