A field is a category of information that contains items. The column headings in the original data source become the fields in your Pivot Table. There are two types of fields:
Page / Row / Column
Data
Note: In the Pivot Table below, click the different fields to learn more.
|
Field Type |
Field Label |
Description |
|
Page |
Store |
Allows the user to display a summary of all of the items in a field or easily drill down by selecting one specific item which filters out all of the other items. |
|
Row |
Sales Rep |
A field whose items display in rows. |
|
Column |
Product |
A field whose items display in columns.. |
|
Data |
Unit |
A field that contains data which you want summarized. Some of the different ways the data can be summarized includes: summing, averaging, or counting. |