Database Reference
In-Depth Information
The types of data fields that you would drop here include those that you want to group and
categorize, such as products, names, and locations.
Columns area
The Columns area contains headings that stretch across the top of columns in the PivotTable. In this
example, the Columns area contains the unique list of business segments.
Placing a data field into the Columns area displays the unique values from that field in a column-oriented
perspective. The Columns area is ideal for creating a data matrix or showing trends over time.
Filters area
At the top of the PivotTable, the Filters area is an optional set of one or more drop-down controls. The
Filters area contains the Region field, and the PivotTable is set to show all regions.
Placing data fields into the Filters area allows you to change the views for the entire PivotTable based
on your selection. The types of data fields that you'd drop here include those that you want to isolate
and focus on; for example, region, line of business, and employees. Data fields dropped into this area
are commonly referred to as filter fields.
Creating the basic PivotTable
Now that you have a good understanding of its structure, follow these steps to create your first
PivotTable:
1. Click any single cell inside your source data (the table you use to feed the PivotTable).
2. On the Insert tab, click the PivotTable button's drop-down list and choose PivotTable.
The Create PivotTable dialog box opens, as shown in Figure 2-2.
Figure 2-2: The Create PivotTable dialog box.
 
Search WWH ::




Custom Search