Sorting rows in the pivot table

To sort the pivot table by values of an aggregation:

1. Click the header of the aggregation in the pivot table

To sort within the first pivot column:

1. Check the box labeled Sort within first pivot column

To restore the original row order:

1. Click the header of any pivot column

See also:

• Adding a column to a pivot
• Creating an aggregation in the pivot table
• About the Pivot view

---

Back to Wizard Help