Sort (week + day) on chart

[Anonymous]

Hello,

i search to sort a chart on Week + Day.

I have discribe my problem on the attached file.

Thanks for your help.

Sophie

[Anonymous]

It's not good for me.

Look in my exemple s.27 mer. must be before s.27 jeu.

Sophie

[hector · Accepted solution]

Hi, use this calculated dimension (or create it in the script)

=dual([Semaine Jour enlèvement],[SemaineEnlèvement]*10 + [JourEnlèvement])

So, if the week is 26 and the day is 5, this will return 260 + 5 -> 265, then order by "numeric value"

rgds and good luck.

[Anonymous]

Good for me

Thanks

Sophie