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.