Pivot table sort order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ajnmx - 27 Mar 2007 18:37 GMT

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.

Reply to this Message

Debra Dalgleish - 27 Mar 2007 21:45 GMT

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

> 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.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message