Correcting the order of weekday names

[thampton]

I have a table that has a date column, a second column created with WEEKNUM, and a third column that uses SWITCH to show the day of the week [name]. When I use the column showing the name the days are out of order. How can i get them to show correctly?

[Greg_Deckler · Accepted solution]

Change your "Sort By" column to one that has numeric order of weekdays.