how to sort month by order?

[#1]

hi to all,

Anyone of you explain how to sort the month by order.

My month dimension like below

month:

Apr

Aug

Jul

Jun

Sep

Oct

Nov

Mar

May

Jan

Feb

But I want month list like

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Nov

Dec

[sudha3295]

How about using Dual function in load statement. I got to learn that it can be used to maintain sort order for text field.

Example

Load dual ( NameDay,NumDay ) as DayOfWeek inline

[ NameDay,NumDay

Monday,0

Tuesday,1

Wednesday,2

Thursday,3

Friday,4

Saturday,5

Sunday,6 ];