A
Alan B
I have a pivot table sorted on a field name. I don't want to change how the
pivot table itself is sorted, but I would like to know if I can change the
drop downs to show their individual items in alphabetical order i.e. my table
is sorted on field 3, but when i click on the drop down for field 1, theitems
are not sorted alphabetically. Any ideas?
Alan
Fife
Scotland
pivot table itself is sorted, but I would like to know if I can change the
drop downs to show their individual items in alphabetical order i.e. my table
is sorted on field 3, but when i click on the drop down for field 1, theitems
are not sorted alphabetically. Any ideas?
Alan
Fife
Scotland