Ordering Pivot Weekday column Mon-Sun
I have a pivot table that is pivoting on a weekday column. How can I get this displaying in order Mon-Sun?
Currently, I have added a custom column “weekdayOrder“ as the first pivot column and a wid...
Forum Discussion
Hi Laflet ,
You can add a field to the cube, in which you can add spaces before the names of the days.
They are not displayed on the visual, but the space will be in the first place when sorting in ascending order.
You can add two spaces and it will come before one space.
Add this column to the table and see the right order.
The result column will be like this:
' monday'
' tuesday'
' wednesday'
' thursday'
'friday'
'saturday'
'sunday'
Always here to help,
Angelina from QBeeQ
[email protected]
Much better!! Thank you Angelina_QBeeQ
