View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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 --