Forum Discussion
ISO Week Problem with order or month split
You have two separate requirements, and need to solve them in two separate ways - as you do already with your two visuals.
You cannot combine these into a single solution. They have to stay separate.
The week has to split up as it is present in separate months. If you want it to show combined then you need to create a separate composite key Year-Week (removing the Month)
In this case, I would have the same problem again in January that week 53 would be sorted incorrectly in January. Since I can no longer sort the "year-week" column by the hidden week number column.
You have two separate requirements, and need to solve them in two separate ways - as you do already with your two visuals.
You cannot combine these into a single solution. They have to stay separate.
Hi there Anonymous , I know that im more than year late, but if you are working with ISO (week) Format, how can be possible that you have week 53?
