i can think of two options.
1) in your script, when you are loading the month name use the dual function to add a number to the month name that way you will have for each month the proper month number, for example Jan will have 1 and March will have 3.
then in your chart go to sort tab and sort using numeric asc or desc.
2) go to sort tab in your chart, and under expression sort them using the match function:
You can try these way:
Create a field in script by using
Num(Month(DateField)) as MonthNum;
Expression : MonthNum
Load Order: Ascending
If ur data is load in ascending order like Jan, Feb,....
Expression: match(Month,'Jan','Feb','Mar' ...)
Thanks for your reply!!
The field MO_SHRT_NM is contains the values as Aug,Sep,Mar,...Dec.
this field i am using as dimention in a combo chart...there i am facing the sorting issue.
without knowing more about your app, i would suggest
to use an inline table with
which connects to your MO_SHRT_NM and you can use sortnr in the sortfield