Excel 2007 Pivot table's Report filter fields value sorting

G

Guest

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
 
R

Roger Govier

Hi

Drag the field to the Row area.
Click the dropdown on Row Fields>select the field you have just dragged
there>More sort options>click Ascending

Now drag the field back to the Report Filter area
 
S

Shelia

Thank u, thank u, thank u....I've been searching for this solution for weeks now. It has truly solved the sorting problems I was having. Thanks again...lesson learned.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter drop down box in pivot table 1
Storing Multiple Selected Pivot Table Report Filter Values 2
Making report in WORD file by using information from Pivot table 3
2007 - Pivot Talbe: Sort Report Filter 2
Excel Pivot Table - Sort Report Filter Values 3
I don't see the Pivot table field list window 2
Update Filter List AFTER Filter Applied 3
Multiple pivot tables on same sheet with common report filter 1

Top