Sorting problem in chart

[#1]

I have the following dimension in my chart

if(region_short_name='KAR',Gen_Date_Mn)

where Gen_Date_Mn is jan,feb,mar,apr,may,jun,jul,aug,sep,oct,nov,dec

i want to show the chart in these way

Jun,Jul,Aug,Sep,Oct,Nov,Dec,Jan,Feb,Mar,Apr,May

[swuehl]

You can try a sort expression like

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

[nilesh_gangurde · Accepted solution]

Hi sumitthakur,

In the sort tab mark the expression and write the expression as given below :

if(wildmatch(Gen_Date_Mn,'Jun'),1,if(wildmatch(Gen_Date_Mn,'Jul',2,if(wildmatch(Gen_Date_Mn,'Aug'),3,if(wildmatch(Gen_Date_Mn,'Sep'),4)))))

and do the same for all the months.

I am sure that It will help you.

Regards,

Nilesh Gangurde