Pivot tabels -- Incorrect sorting of specific value in pivot table

[Guest]

A message was posted yesterday that has not shown up so this is a second
attmpt.

I have a pivot table that consistently places a value at the top of the
sorted llist (bottom if decending) even though that value should be in the
middle of the list. A sample of the values are ALC, SNO, CET, ESU, TEL,
STR, JUN, NKA, NTL, blank. The JUN value is always at the top. Any value
placed in the field that begins with J shows at the top. If the value is
changed to any other letter, it sorts correctly. The data has been reentered
at the source, the query checked, and the downloaded data checked. All place
the value in the correct position when sorted at those repective places. It
is only in the pivot table where the item does not sort correctly. I am
using Microsoft Office 2000 SR-1 Professional Excel 2000 (9.0.3821 SR-1)

 

[Debra Dalgleish]

If you type your name in the Author box in Google's advanced search for
newsgroups, you can find your old threads:

http://groups.google.com/advanced_group_search?as_ugroup=*excel*

I answered your question yesterday, as follows:

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.