Sort by Expression

[#1]

Hi,

I was trying to Sort by Expression but i'm not able to do it please answer if any one can.

i have one calculated dimension ("Month(OrderDate)&Year(OrderDate)") and i have selected sort by expression ("OrderDate").

Don't know why this is not working..

Thanks in advance for your answer and effort.

[ariel_klien]

Hi,

Try to put in the dimension Date(OrderDate,'MMYYYY')

and in the sort by put date#(OrderDate)

BR

Ariel

[tresB · Accepted solution]

Instead, try MonthName(OrderDate)  as your calculated dimension and sort by numeric order.

[#4]

Thank you ...:)

it's working...