O'Reilly logo

2007 Microsoft® Office System Inside Out by Microsoft Corporation

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sorting PivotTable Fields

You can sort a PivotTable field either by its own items (for example, alphabetizing the categories in Figure 15-11) or on the basis of values in the body of the table (for example, sorting categories in descending order of sales totals so 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 click Sort A To Z or Sort Z To A if you want to sort the field by its own items. 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 on the next page (with the name of the field you selected in the title of the dialog box).

To sort by values in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required