Sort Week number

[elandy]

I have a simple problem and i couldn't find the answer anywhere.

I have a CrossQuery sum some values by weekNumber

(yyyy/ww)



Week Number | Jason | Bourne | Neo |
2017/23 | | | |
2017/36 | | | |
2017/47 | | | |
2017/50 | | | |
2018/1 | | | |
2018/10 | | | |
2018/11 | | | |
2018/2 | | | |
2018/23 | | | |

How to sort by week number? Like This

Week Number | Jason | Bourne | Neo |
2017/23 | | | |
2017/36 | | | |
2017/47 | | | |
2017/50 | | | |
2018/1 | | | |
2018/2 | | | |
2018/10 | | | |
2018/11 | | | |
2018/23 | | | |

Thanks,
Elandy

[isladogs]

Despite its name, your Week Number field is a text string due to the '/'
So its correctly sorting each character as text in turn
To fix, you need two other number fields YearNo & WeekNo and sort by both of those fields instead.
The two fields can be hidden if you wish

[elandy]

Many thanks!
It work
I used Expr1: PartData("yyyy";[fieldname])
and
Expr2: PartData("ww";[fieldname])

i sorted this to filds and hidden!

[ArviLaanemets]

A simpler way is format the week number like
'2018/01'
or
201801
i.e. the week number itself is always 2 numbers. This allows to apply correct sorting for either of formats.