Sort data in a field

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

1. Do one of the following:

   • To sort the data in a field based on the item labels, click the label of the field that contains the data you want to sort.

   • To sort the data in a field based on the summary values in a column, click a cell in the column that contains the values that you want to sort on.

   • To sort the data in a field based on subtotal or grand total values, click a subtotal or grand total value for the field that contains the data you want to sort.

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.

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.