Excel Pivot Tables not sorting the word SUN properly

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

Guest

When creating a pivot table based on an Excel list, the word SUN is not
sorted properly when using the pivot table advanced sort options.
 
SUN goes to the top of the list because Excel assumes it means Sunday,
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, SUN sorts
to the top, and the other items appear below, because they're not in the
Weekdays custom list.

If you manually sort the list, SUN should move to the correct position
alphabetically. Or, perhaps you could add a space at the end of SUN in
the source table.
 

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

Back
Top