Pivot table not alphabetizing correctly for one character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excell from Microsoft Office 2000 SR-1 Professional, after setting the
pivot table to sort in ascending values, the field is sorted for all values
except for one. This one lists at the top (or bottom if descending values)
of the pivot table no matter what I've tried. The following are some of the
field values: ALC, STC, NTL, DEF, LUC,MOL, JUN,SNO. When sorted, all are
alphabetized except JUN. That value always is at the top. I've checked the
original data, the query, and the excel data. All appear consistent and sort
appropriately, the pivot table will not. If I change the data to something
that begins with something other than J it appears to work. Can you help?
 
JUN goes to the top of the list because Excel assumes it's the month
name for June, and it appears in one of the built-in custom lists.

When you create a pivot table, and Excel detects an entry from a custom
list, it uses that list as the sort order. So, in your table, JUN sort
to the top, and the other items appear below, because they're not in the
Months custom list.

If you manually sort the list, JUN should move to the correct position
alphabetically. Or, perhaps you could add a space at the end of JUN in
the source table.
 
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

Pivot tabels -- Incorrect sorting of specific value in pivot table 1
Pivot Table Soret 1
Sort in a Pivot Table 1
Pivot Table Sort Order 1
Pivot Table - Compare Dates & calc. % 1
Pivot table drill down data 2
Pivot Table Data Column Sort Excel 2007 1
Pivot table not sorting 2

Back
Top