Pivot table sort order

[ajnmx]

If I go into PivotTable Field Settings, then Advanced, there's an
option under AustSort Options for "Manual (you can drag items to
rearrange them)". How does this work? I can't see where I can drag &
drop items, it doesn't work on the spreadsheet & I can't see where
elese to do it? The only sort order I can seem to work is ascending
or descending.

 

[Debra Dalgleish]

Select a cell that contains a pivot item for that field.
Point to the border of the selected cell
When the pointer changes to a four-headed arrow, drag the item to a
different position in the list of items.

Or, you can right-click on a cell that contains a pivot item.
From the shortcut menu, choose Order, then click on one of the Move options