Excel 2007 Pivot table's Report filter fields value sorting

A

Amigo

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Weekly Report 2
Slicers and Calculated Items in Pivot Table 2
Excel does not accept text format! 0
Filter drop down box in pivot table 1
VB Macro for Pivot Filter Function 0
Pivot table report invalid 0
Storing Multiple Selected Pivot Table Report Filter Values 2

Top