Microsoft® Excel® 2010 Inside Out

Sorting PivotTable Fields

You can sort a PivotTable field either by its own items (for example, alphabetizing the categories in Figure 23-11) or on the basis of values in the body of the table (for example, sorting categories in descending order of sales totals so that the best-selling categories appear at the top). To sort a field, right-click any item in that field, and then click Sort. On the menu that appears, you can specify how you want to sort (for example A to Z or Z to A in the case of a text column). If you want to sort the field by values in the body of the table, click More Sort Options. You’ll see a dialog box similar to the one shown here (with the name of the field you selected in the title of the dialog box).

To sort by values in ...