| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 -- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 -- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert the same field twice in an Excel 2007 pivot table | Excel Worksheet Functions | |||
| Summin Pivot Table data from a date selected in the Page field | Excel Discussion (Misc queries) | |||
| Pivot Table Page Field Area Broken | Excel Discussion (Misc queries) | |||
| Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
| I cannot drag a Pivot Table field into the page area | Excel Discussion (Misc queries) | |||
Linear Mode
