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.
 
You must log in or register to reply here.

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

Similar Threads

Help with VLOOKUP & MATCH formula 5
repeat row labels in pivot table 2
Preferred way to do sort order - column in table, or specified in query? 3
Sorting in Custom Alphabetical Order 2
Trailing 3 month sales 9
Pivot table active dropdown 5
Pivot Table 1
PIVOT - refresh pivot based on Field / item 1

Back
Top