Page 10 of 16PREVNEXT

PivotTable I: What's so great about PivotTable reports?

Column headings from the worksheet become fields on the PivotTable Field List

Callout 1 Column headings on the worksheet...
Callout 2 ...become fields on the field list.

In the PivotTable Field List are the names of the columns from the source data (the sales figures): Country, Salesperson, Order Amount, Order Date, and OrderID.

Each column in the source data has become a field with the same name. Dragging fields from the field list and dropping them onto the layout area is how you would create a PivotTable view of your data.

Page 10 of 16PREVNEXT