manual sort in a pivot table field

  • Thread starter Thread starter Cathy B
  • Start date Start date
C

Cathy B

I have a field called area which can bring have 3 values -
East, Central and West. I want to sort them in this order
vs alphabetical. I can arrange them in the row area of my
table and they look ok, but after I refresh them they end
up in the sequence East, West, Central. I can't figure
out how to get them to stay sorted as East, Central, West.

Any help would be appreciated.
Thank you.
 
Just one way, but you can always do an Edit Replace on your source data and make
the data:-

East ==> '1 - East'
Central ==> '2 - Central'
West ==> '3 - West'
 
I don't think an Edit Replace on the source data will be
acceptable to my users. What is the Just one way? I
checked out the custom list and was able to enter a
custome list, but I can't get the sort to stick with the
custom list.

Again - I appreciate any help I can get.
 
Back
Top