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:


Back to Wizard Help