Pivot Table Report Filter Sorting


T

Travis

Is there a way to sort the items in a Pivot Table Report Filter
alphabetically or numerically in Excel 2007? I notice that that they
currently appear in the order in which they are present in the raw data.
 
Ad

Advertisements

K

KC Rippstein hotmail com>

Yes, decide which field you want sorted, right-click on any of that field's
entries, then under the "Advanced..." tab you'll see AutoSort options on the
left ("Manual" is the default).

As you will see when you get there, you can select any "key sort" field you
want from this screen once you get to it. Maybe instead of alphabetically
you want it sorted descending by greatest sales.
 
T

Travis

Thanks for your feedback, although I may have not described the situation
correctly. I have a filter on my pivot report. When I click on the "down
arrow" of that filter, the items that appear in that list are not sorted in
any particular way. I am wondering if there's a way to sort those items, not
the actual data in the pivot report.

Thanks again,
~Travis
 
Ad

Advertisements

K

KC Rippstein hotmail com>

Drag the field to the row area (if not already there), select it's header and
in the Excel toolbar hit the A>Z sort button. Then if needed drag it back to
the Page or Column area. I'm fairly sure that should take care of it.
 

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

Top