Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Can anyone help me to sort months in a proper order.
Thanks
Manisha Choudhary
If you use the Month([Date Field])-command to create your month it shoud sort correctly.
there are many ways to sort
load * inline [
Month,no
Jan,1
Feb,2
Mar,3
Apr,4
May,5
Jun,6
Jul,7
Aug,8
Sep,9
Oct,10
Nov,11
Dec,12
];
go to charts properties->sort-> seleect monthfied from leeft pane ->expression->no
or
in same place write
wildmatch(Monthfieldname,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')
thanks
Sunil