Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2007 Pivot table's Report filter fields value sorting
Hi,
I have an excel sheet with huge data in a pivot table and some report filters for the pivot table. but the list for each report filter is not sorted. how do i get a sorted list for each report filter. Any help would be appreciated. thnx in advance |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2007 Pivot table's Report filter fields value sorting
Hi
Drag the field to the Row area. Click the dropdown on Row Fieldsselect the field you have just dragged thereMore sort optionsclick Ascending Now drag the field back to the Report Filter area -- Regards Roger Govier "Amigo" wrote in message ... Hi, I have an excel sheet with huge data in a pivot table and some report filters for the pivot table. but the list for each report filter is not sorted. how do i get a sorted list for each report filter. Any help would be appreciated. thnx in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table - Sort Report Filter Values | Excel Discussion (Misc queries) | |||
PIVOT TABLE's Custom Calculated Fields | Excel Discussion (Misc queries) | |||
anchor fields to pivot table (Excel 2007) | Excel Discussion (Misc queries) | |||
Changing a pivot table's data range in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 PivotTable Report Filter area not working | Excel Discussion (Misc queries) |