Pivot table sort order
 

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.

Pivot table sort order
 

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

ajnmx wrote:
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
Contextures
http://www.contextures.com/tiptech.html