Pivot Table Sort Page Filters? 1

[AccessHelp123]

Hi,

I created a pivot table which has country name as one of the page filters. When I try to filter the data in the pivot table using country and click on the drop down icon I noticed that the country was not sorted in alphabetical order in the drop down list. Is there any way I can sort the drop down list of the page filters in a pivot table? I am using Excel 2003. Thanks.

 

[SkipVought]

Hi,

Right-click the PAGE field.

Select Field Settings

Hit Advanced...[/b[ button

Select the AutoSort Option of your choice.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[AccessHelp123]

Thanks! That worked.