Sorting Page Area Field Data in Excel 2007 Pivot Table
 

In the old days (2003) you could right click a field, select properties, then
hit advanced and you could tell how you wanted to sort the field data in the
Page Filters of a pivot table. I can't see how to sort in Excel 2007 --

Any help would be appreciated . . .

Thank you --

Sorting Page Area Field Data in Excel 2007 Pivot Table
 

Hi

It seems to have been missed out.
Drag the field to a Row or Column area, click the dropdown and choose the
Sort option you want.
Then drag back to Report Filter area

--
Regards
Roger Govier

"Rubble" wrote in message
...
In the old days (2003) you could right click a field, select properties,
then
hit advanced and you could tell how you wanted to sort the field data in
the
Page Filters of a pivot table. I can't see how to sort in Excel 2007 --

Any help would be appreciated . . .

Thank you --

Sorting Page Area Field Data in Excel 2007 Pivot Table
 

Thank you !!

"Roger Govier" wrote:

Hi

It seems to have been missed out.
Drag the field to a Row or Column area, click the dropdown and choose the
Sort option you want.
Then drag back to Report Filter area

--
Regards
Roger Govier

"Rubble" wrote in message
...
In the old days (2003) you could right click a field, select properties,
then
hit advanced and you could tell how you wanted to sort the field data in
the
Page Filters of a pivot table. I can't see how to sort in Excel 2007 --

Any help would be appreciated . . .

Thank you --