Excel Pivot field list sorting

**maxik** · 05-22-2007, 04:41 PM

Hi all,

I have looked around and haven't been able to get a solution to my problem: I need to sort the field list of the excel pivot table (when you click on the field to expand it to have the available fields sorted).

Does anyone know a solution to this? Thanks in advance!

Snapshot attached.

**tuph** · 05-22-2007, 06:48 PM

Double click on the middle of the field button then click Advanced and you will find some sort options.

**maxik** · 05-23-2007, 08:17 AM

Originally Posted by tuph

Double click on the middle of the field button then click Advanced and you will find some sort options.

tuph: it's not what I need though. I need to sort the list in the window itself, not the results (look at the attachment). By the way the attached list is sorted but it's for an example only. Thanks!

**tuph** · 05-23-2007, 05:45 PM

Originally Posted by maxik

tuph: it's not what I need though. I need to sort the list in the window itself, not the results (look at the attachment). By the way the attached list is sorted but it's for an example only. Thanks!

Sorry, Maxik. I thought sorting the field would sort the list also. Someone with more expertise than I needs to look at this.