Sort data in a PivotTable list
- In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
- Do one of the following:
Sort in ascending or descending order
You can sort data that is displayed in natural or custom order in ascending or descending order.
- 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.
-
- On the 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.
- Select the item you want to move.
- Drag the selected item and drop it over the item above which you want to place it.
- 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.
- Do one of the following:
Notes
- To switch from ascending or descending sort to custom sort, click Sort Ascending or Sort Descending so that the button is not selected.
- The order in which numbers, text, and special characters are sorted depends on the source data and your regional settings in Microsoft Windows Control Panel. If users have different regional settings in their browsers, their sort orders might be different from yours.