Page 10 of 16PREVNEXT

PivotTable II: Swing into action with PivotTable reports

Data before and after being sorted by amount sold

Callout 1 Salespersons sorted by name, alphabetically.
Callout 2 Salespersons sorted by amount sold.

The purpose of the PivotTable report is to see how much each salesperson has sold, so it would make sense to see the names listed in order by the amount sold instead of alphabetically. That way your manager could see at a glance, for example, who gets the biggest bonus.

Sorting starts by clicking PivotTable on the PivotTable toolbar, and then selecting Sort and Top 10. In the practice session, you'll find step-by-step instructions for how to sort.

Page 10 of 16PREVNEXT