Month Sort

[#1]

My month Data is in excel in proper month order and I loaded the data as a crosstable. However, I am having an issue sorting the months. I do not have specific dates, just the month and the values underneath

[MK_QSL · Accepted solution]

Can you provide your sample data file?

meantime you can use...

Load * Inline

[

     Month, MonthNO

     Jan, 1

     Feb, 2

etc

];

and sort by MonthNO...

ALso you can use Dual Function also.

[uttamdwibedy]

Provide the sample data file

[veeranj]

HI Fernando,

GO the the SORT tab and then check Load Order Original option.

Thanks,Anjee

[#5]

Thanks for the response, here is a picture of how my data is in excel, I tried the Load Order Original and did not work

CrossTable

(SalesMonth, SalesData, 4)
LOAD Version,
[Org Name],
[Sales Type],
Revenue,
JAN,
FEB,
MAR,
APR,
MAY,
JUN,
JUL,
AUG,
SEP,
OCT,
NOV,

DEC

[#6]

Thank you, this helped!

[veeranj]

Hi,

here is the other way

in the sort tab ,select months data column  and then write this expression

match(months,'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

this will work .

Even the above example what i said is working for me.

the thing is that you have to deselect TEXT(A->Z) OPTION AND THEN select load order original.

for ur reference attching the image.

As ur months are in order in excel ,so u can go for this load order option.

or else u can go for above expression.

Thanks ,

Anjee