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: