Pivot Table Column/Row Display Order

[aljodo]

Hi All,

I have a pivot table that displays hours and values summarised on Classification rows and Grade columns.

The data I am using looks like this:-
Employee Class Grade Hours Value
A Smith Admin Assistant 1.2 24.00
G Wilson Planning Senior 2.0 90.00
G Wilson Creditors Senior 0.8 36.00
etc...

The problem I have is that the Classification and Grade columns are not coming out it any discernable order. It is grouping the data correctly, but not sorting them alphabetically - which is what I had expected.

Any ideas as to how I can ensure that they come out in the expected order please?

TIA,

Alan.

 

[xlbo]

right click on field
choose Field Settings
Choose Advanced
Use the autosort options

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[SkipVought]

Hi,

If you do into the Pivot Table Field Properties, you can specify the sort order.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[aljodo]

That's sickeningly easy!!

Thank you very much.

Alan.

 

[SkipVought]

Need a barf bag? ;-)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com