Sorting the Pivot Table dimension values

For each Pivot Table row and column dimension, you can determine the order for displaying dimension values.

At the top left of the Pivot Table are the headings with the dimension names.


Top left of the Pivot Table showing the dimension headings

To switch the display order of the values for a dimension, click the dimension heading.