Sort order

[mato32188]

Hello,

I have a problem with sorting year-month dimension in chart. Format is 20XX-Jan, 20XX-Feb

Could anybody help to sort it chronologically?

Thanks

[ashfaq_haseeb · Accepted solution]

Hi use

date(Datefield,'YYYY-MMM')  as your sorting expression

Regards

ASHFAQ

[mato32188]

It works only when expression is..... date#(Datefield, 'YYYY-MMM'), but thank you very much.

[vardhancse]

Hi,

In the calendar can u create the inline statements separately for year and month with sort numbers.

LOAD * INLINE [

    Year, Sort_No

    2006, 1

    2007, 2

    2008, 3

    2009, 4

    2010, 5

];

Similarly for month,

LOAD * INLINE [

    Month, Sort_No

    Jan, 1

    Feb, 2

    Mar, 3

];

So that in front end u can join both .