Chart sorting

[#1]

Hello,

I have a difficulty to sort a chart with a calculated dimension.

I have a calculated dimension which displays 'YEAR'&'/'&'WeekNr', and is not sorting in correct order. I've tried all the possibilities.

=year(Date)&'/'&week(Date)

Do you have any suggestions ?

See the attachment.

Thank you,

Claudiu

[its_anandrjs]

In the sort properties

write in Sort By box and deselect all also you can select Load Order -> Original.

=year(Date)&'/'&week(Date)

Regards

Anand

[marcus_sommer · Accepted solution]

For this you need a dual-function, like:

dual(year(Date) & '/' & week(Date), year(Date) * 100 + week(Date))

whereby it would be better to use "native" period-fields created within a master-calendar instead of using calculated dimensions: How to use - Master-Calendar and Date-Values

- Marcus

[alexandros17]

Try With:

YEAR & '/' &' Num(Week,'00')' & 'Nr'

[#5]

Thank you very much Marcus ! It worked.