Sort Problem

[#1]

Dear Experts,

How I can sort this table in month order(calender order).  

Rgds,

Priyantha.

[mohammadkhatimi · Accepted solution]

Hie...

Write this expreesion in sort tab

=wildmatch(capitalize(only({1}Month)),'APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC','JAN','FEB','MAR')

Regards,

MOhammad

[ecolomer]

In Sort tab, write:

=only({1} match(MONTH, 'APR', 'MAY','JUN','JUL','AUG','SEP','OCT') )

[#4]

Hi Mohammad,

Really It works............!!!

Thanks lot.

RGDS

Priyantha.

[jagan]

Hi,

Try to generate Master fiscal calendar and use that Month field in your chart, no need to this manually in all the charts.  This is the best approach.

Check below link for Master calendar generation

Fiscal and Standard Calendar generation

Regards,

Jagan.

[#6]

Dear Colomer,

Thanks lot for the help.

RGDS,

Priyantha.

[satishkurra]

Also with the above replies and correct answers try this way from back end

Temp:

LOAD * Inline [

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec ];

Here load the Month column date from source

Now drop the temp table

Drop Table Temp;

This approach will help in giving good performance instead of loading your expression in Presentation layer

Thanks

Satish

[#8]

Dear Satish,

Definitely I will try your method.

Rgds,

Priyantha.

[#9]

Dear Jagan,

Definitely I will try your method.

Rgds,

Priyantha.