Page 135 - Excel Data Analysis

08 537547 Ch07.qxd 3/4/03 12:07 PM Page 121

WORKING WITH PIVOTTABLE REPORTS 7

A VIEW OF THE PIVOTTABLE REPORT FIELDS

You add imported fields to your PivotTable report by One nice feature of a PivotTable report is that Excel
dragging them onto one of four different areas: Page, automatically inserts a row and a column to provide a total
Column, Row, and Data. Although you can add a field to for the values in the corresponding rows and columns of
any of the four PivotTable areas, the placement determines the PivotTable report.
the layout of the report.

ROW FIELD ITEMS
Identifies the values from Identifies a sub-category for
the source data assigned a row or a column that
to the row orientation. identifies the corresponding
data area values.

PAGE FIELD
An optional field that
filters the values on the
page. Only records
containing matching SUB TOTAL
values display on
the page. A row or column that
summarizes cells within the
corresponding detail fields.

DATA FIELD
GRAND TOTAL
Identifies the values from
the source data that are A row or column that
summarized in the Data provides a total for all
area. cells in the cells of the
data area.
COLUMN FIELDS DATA AREA
Values from the source data Summarizes the data
assigned to the column values using the assigned
orientation. summarization function
or custom formula.

121