Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Learning the PivotTable Lingo

Here is some PivotTable lingo that you need to know before you work with pivot tables.

• Item— An item label is a subcategory of a PivotTable field and is derived from unique entries in a database field or in a list column. Items appear as row or column labels or in the lists for page fields in a pivot table report.

• Row field— Row field labels have a row orientation in a pivot table report and are displayed as row labels. Appears in the ROW area of a pivot table report layout.

• Column field— Column field labels have a column orientation in a pivot table report and are displayed as column labels. Appears in the COLUMN area of a pivot table report layout.

• Data field— Data fields from a list or table contain summary data ...