I have a field called 'Day' that has data for Days of the Week.
I put the Day field in the 'Column' section of the layout for the Pivot Table.
The order is alphabetical meaning Friday comes first, followed by Monday and then Saturday and so on.
How in a Pivot Table can I correct the order manually, so the days of the week would be in the proper order?
That is, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.