However, you’ve got the option to override this default behavior.
Lets take a look.
When you add a label field to a pivot table, the items in that field are sorted alphabetically.
For example, if we add Product as a row label to this pivot table.
We get sales by Product, with all products listed alphabetically.
This sorting is automatic for column labels as well.
To re-sort in alphabetical order, nudge the A-Z button.
you could do the same thing with Cities.
Just select any city, and sort.
you might also sort row and column labels by more than one level.
To illustrate, lets remove the City field.
Products are now sorted in simple alphabetical order.
Now, lets add the Category field above Products.
If we select a product and sort, the products are sorted, but the categories remain unchanged.
Notice that after youve sorted a pivot table, the field filter drop-down displays a special sorting icon.
If you hover over this icon, Excel will show the current sort options.
Also note that a pivot table remembers Sort Options for a given field, even when its been removed.
