Reorder pivot table field lists

J

Josh Johansen

I have a long list under certain pivot table fields, and I would like to
reorder them so they are not in alphabetic order. I have read in help that
you can drag and drop manually, but for some reason I cannot figure out how
to do it. Any ideas what I am doing wrong? Thanks.
 
B

badger_rich

Make sure that AutoSort Options are set to Manual for the field you are
trying to sort manually.

Right Click (or double-clcik) on the field name, choose "Field Settings...",
click on "Advanced" and select 'Manual ("you can ...")' under AutoSort
Options
 
J

Josh Johansen

When I double click on the field, it brings up the PivotTable Field box, I
then click on advanced, and the manual button is selected, but top 10
autoshow is greyed out, and I am unable to manually drag to reorder like it
says I should be able to. I tried to figure out what you meant by autosort
options set to manual, but have been unable to figure that out, any help?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table field reordering 0
Pivot Table Field Reordering 4
Problem with SET & REF function 0
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Slicers and Calculated Items in Pivot Table 2
Pivot ... Drag Multiple Fields from Field List? 1
Different ways to build Pivot table 1

Top