Sorting rows

To sort the rows of a pivot table:

1. Activate the table.
2. Select any cell in the column you want to use to sort on. To sort just a selected group of rows, select two or more contiguous cells in the column you want to use to sort on.
3. From the menus, choose:

   Edit > Sort rows

4. Select Ascending or Descending from the submenu.

• If the row dimension contains groups, sorting affects only the group that contains the selection.
• You cannot sort across group boundaries.
• You cannot sort tables with more than one item in the row dimension.

Note: This feature is not available in legacy tables.