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

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