Page 11 of 16PREVNEXT

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

Field headings dragged from Field List to layout area

Use drop areas to control the report organization.

The layout area is divided into separate outlined drop areas onto which you'd drag and drop fields from the field list. The layout area will become your PivotTable report.

Labels on the drop areas tell you where to drop data to display it in a specific orientation. If you were to drag the Salesperson field into the area labeled Drop Row Fields Here, for example, you would see one row for each salesperson's name. If you dragged the Salesperson field into the area labeled Drop Column Fields Here, you would see one column for each salesperson's name.

Next you'll see how to determine which fields to drop onto the layout area (you don't have to use all of them).

Page 11 of 16PREVNEXT