Sort data in a field

Sort in ascending or descending order

You can sort data that is displayed in natural or custom order in ascending or descending order.

  1. Do one of the following:
  2. On the PivotTable list toolbar, click Sort Ascending or Sort Descending .

Note   To sort on multiple fields, start by sorting the innermost field first and work backward, sorting the outermost field last.

Specify a custom sort order

  1. Select the item you want to move.
  2. Drag the selected item and drop it over the item above which you want to place it.
  3. Repeat steps 1 and 2 until you have the items in the order you want.

Note   If a field with custom sorting has a parent field, each parent member will display the lower-level members in custom order.

Notes