Pivot Table Report Filter Sorting
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.
--
Please remember to indicate when the post is answered so others can benefit
from it later.
"Travis" wrote:
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.
|