Day of Week not in correct order (should be in order of days of the week)

[metabaserocks]

I have made a pivot table with hour of the day on the y axis and Day of the week on the x axis

It looks like it is sorting day of the week alphabetically but I want it to sort the day of the week by the day of the week, as is my settings in Admin area (Monday first day)

How does one do this? Or is it not possible?

[metabaserocks]

Update: I solved this by creating a combined column with the Day of the week as an integer and that works