Sort data in a PivotTable
To help you locate data that you want to analyze in a PivotTable report more easily, you can sort text entries (from A to Z or Z to A), numbers (from smallest to largest or largest to smallest), and dates and times (from oldest to newest or newest to oldest).
When you sort data in a PivotTable report, be aware of the following:
Data such as text entries may have leading spaces that affect the sort results. For optimal sort results, you should remove any spaces before you sort the data.
Unlike sorting data in a range of cells on a worksheet or in an Excel for Mac table, you cannot sort case-sensitive text entries.
You cannot sort data by format, such as cell or font color, or by conditional formatting indicators, such as icon sets.
Sort orders vary by locale setting. Make sure that you have the correct locale setting in Language and Text in System Preferences on your computer. For information about changing the locale setting, see the Mac Help system.
Do any of the following:
Sort row or column label data in a PivotTable report
Customize the sort operation
Sort by using a custom list
Sort data in the values area