sorting of calender week (with year change)

[Pikachu-Power]

Hello all,

for a bar chart I have year / month / cw / date levels. when I use YEAR_CW like

2020 52, 2020 53, 2021 01, 2021 02 and so on...

the sorting works. but when I use the fork arrows i see to many years like "2021 2021 01 2020 53 JAN".

So it is possible to sort the calender week without using the year like 52, 53, 01, 02? (also the same for month)

Thanks.

[amitchandak · Accepted solution]

@Pikachu-Power , I doubt that is possible. It will not allow you to create a sort column.

Check I tried in this video https://www.youtube.com/watch?v=KK1zu4MBb-c

[amitchandak · Accepted solution]

@Pikachu-Power , I doubt that is possible. It will not allow you to create a sort column.

Check I tried in this video https://www.youtube.com/watch?v=KK1zu4MBb-c

[Pikachu-Power]

Do you mean possible or not possible? In your case you can sort YEAR MONTH SORT but for me it doesnt work somehow.

Sorry i clicked accidentally accept the solution. 

[amitchandak · Accepted solution]

@Pikachu-Power , I do not think it is possible. Once you try to create such sort column, you will get error