Sort a PivotTable or PivotChart report

1. On the PivotTable toolbar, click PivotTable, and then click Sort and Top 10.
2. Under AutoSort options, click Ascending or Descending.
3. In the Using field list, do one of the following:

   To sort the items by their labels, click the same field that you're sorting.

   To sort the items by their values in the data area, click the data field that supplies the values you want to sort on.

Note  When you refresh the report or change its layout, Excel resorts the field in the order you specified.

1. Click the cell in the data area that contains the value you want to sort by. For example, if you want to sort your products by a particular month's sales value, click the value for that month in the data area.
2. On the Data menu, click Sort.
3. Select any options you want, and then click OK.

Note  You'll need to repeat the sort if you refresh or update the report.

The custom order is not retained if you refresh the report.

1. On the Data menu, click Sort.
2. Click Options.
3. In the First key sort order box, click an option.

   If you don't see the option you want, you can create your own custom sort order by clicking Options on the Tools menu and using the Custom Lists tab.

Note  You can organize items in a custom order manually by selecting and dragging them.

1. On the PivotTable toolbar, click PivotTable, and then click Sort and Top 10.
2. Under AutoSort options, click Manual to stop automatic sorting or Data source order to return the items to their original order.