Excel 2007 - Pivot Table

[Wajid55]

I have a pivot table in Excel 2007, there are filters on top of the pivot table, is there any way I can sort the values in those Filters?

e.g.
I have Organization Filter list:
1000-
1100-
1200-
1700-
1600-

1600 should be before 1700.

So i want to sort this list.

Any help will be appretiated.
Thank you,

 

[SkipVought]

Hi,

Right click the Row Heading, select Field Settings, hit ADVANCED button, AutoSort - Ascending.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[Wajid55]

Which row heading you are talking about...I asked about filter on top of Pivot table. Even if i click Field Settings on any of the columns or Filters there is no Advanced button to click. The only thing i can see is Subtotals tab with its options and Layout & Print tab.