Sort Month Name

[#1]

Hi,

I have a question. I have load a calendar data successfully. When I want to show Month Field using list box, the first data is Dec not Jan. I have two field to be used in sort column, MonthNum (1-12) and MonthName (Jan-Dec). Anybody knows the method to sort month name correctly ?

Really appreciate your help, thanks

[jagan]

Hi Indra,

For this you need to uncheck the following option

Properties -> Sort -> Uncheck State option.

Regards,

Jagan.

[#3]

Hi Jagan,

I have already uncheck the state option. I only check expression option and add the expression.

Still dont get the problem why. really confuse about it.

thanks

[jagan]

Hi Indra,

Can you attach the sample file?

Regards,

Jagan.

[#5]

Hi,

Sorry Jagan, i cant attach any file.

Is there any possibilities that the problem comes from the load order and makes Dec show in the first row ?

When i'm not choose the month it shows correctly,

Jan - Dec

But when i choose one month i mixed up again.

[settu_periasamy]

Hi,

may be like this, in Sort - > Expression (remove all other sort selection )

=Match(MonthName,'Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov')

[jagan]

Hi Indra,

Can you attach the screenshot of the Sort tab?

Regards,

jagan

[#8 · Accepted solution]

Use Only({1}MonthNum) in Sort tab -> Expression

Regards,

KKR

[#9]

Hi Kran,

Wow, super thanks Kran. It solved my problem. But can you explain why i need to use Only{1} like that ? Still dont get the idea.

Thanks

[jagan]

Hi,

If you use this approach then in every Month listbox in the Dashboard you have to use this.  This is not a feasible solution.

Regards,

Jagan.

[#11]

Hi Jagan

Do you mean that when i select Jan in first sheet, Month in the other sheet will be Jan also ? Can you give me the sample scenario ?

thanks for your opinion