© 2003 American Express Travel Related Services Company, Inc. All rights reserved.
This is confidential, proprietary and trade secret information of American Express Travel Related Services Company, Inc.
Pivot Table - Training
Anatomy of a PivotTable Report
You may have noticed that Excel uses specific terms to identify the parts of a PivotTable report.
If you're not familiar with these terms, read this section for a quick primer.
Row field A field from the source data that you assign to a row orientation in a PivotTable report.
For example, Region and Salesperson are row fields.
Column field A field from the source data that you assign to a column orientation in a PivotTable report.
For example, Type is a column field.
Page field A field from the source data that you assign to a page (or filter) orientation in a PivotTable report.
For example, Year is a page field. You can use the Year field to display summarized data for only 1997, 1998, and so on.
Item A subcategory of a row, column, or page field.
For example, the Type field contains the following items: Beverages, Dairy, Meat, and Produce; the Salesperson field contains
the following items: Buchanan, Davolio, Dodsworth, and Suyama.
Data field A field from the source data that contains data to be summarized.
For example, Sum of Sales is a data field.
Note: You can choose how to summarize data (for example, by sum, average, or count).
A data field usually summarizes numeric data, but it can also summarize text. For example, you can count the number of times a
specific text entry (such as Yes or No) appears in a field.
Data area The cells in a PivotTable report that contain summary data.
For example, the value in cell C5 summarizes Buchanan's beverage sales for the East region in 1997. In other words, it's a
summary of the sales figures for every row in the source data that contains the items Buchanan, Beverage, East, and 1997.
8/1/2023
4
