Changing display order of elements within a dimension

To change the display order of elements within a table dimension (row, column, or layer):

1. Activate the pivot table.
2. If pivoting trays are not already on, from the Pivot Table menu choose:

   Pivot > Pivoting Trays

3. Drag and drop the elements within the dimension in the pivoting tray.