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 --
|