Sort data in a PivotTable list

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. 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.

    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.

        Note   If you click a grand total value in the bottom row, the columns will be sorted instead of the rows.

    2. 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.

    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