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