Pivot Table field list order

K

Kirk P.

I would prefer that the order of items appearing in the pivot table field
list be in the same order as the data source (as oppossed to the default
alphebetical).

Reviewing the posts on this subject, I see where you can determine the
order, via a custom list, once you drag an item onto the report. However,
I'm interested in the order of items that are available to drag onto the
report.
 
J

Jim Thomlinson

To the best of my knowledge the field list order is alphabetical and that is
about your only option...
 

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

How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
Pivot ... Drag Multiple Fields from Field List? 1
Pivot table row field order 6
Pivot Table Sort Order 1
Pivot Table Report formatting - can't select Data Source Order 1
Pivot Table Missing Field List 7
Problem inserting calculated pivot fields into Pivot Table (2007) 1
pivot table - drop down filter box has 10% of items out of order 2

Top