Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i am trying to show monthly statistics but i can't get the moths in order the chart is displayed like the image which i have shown below..
how can i get the correct order??
ex; Jan , Feb ,Mar, Apr, May... etc
thank you in advance
May be like this
go to sort tab select sort by expression --> ascending order
Below is the expression. Make sure to select ascending order.
=match(YourMonthField, 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep', 'Oct', 'Nov', 'Dec')
Regards
ASHFAQ
Hi,
Go to sort tab and play around with sorting there,
or post a sample app.
Regards
ASHFAQ
i did try every thing in the sorting tab but nothing worked
Hi,
Sample app please
Regards
ASHFAQ
i am using a personal edition so i dnt think u will be able to open it even if i post the sample app 😕
Hi,
I can open any application as I have Licence.
But you cannot open any other application.
By seeing your application I can guide you.
Regards
ASHFAQ
Check your data source
Maybe your April Year is different than the others(let say 2015 to 2014 for Jan-May)
i attached my Excel as well
Hi,
Your document is corrupted.
Can you upload it again.
Regards
ASHFAQ
May be like this
go to sort tab select sort by expression --> ascending order
Below is the expression. Make sure to select ascending order.
=match(YourMonthField, 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep', 'Oct', 'Nov', 'Dec')
Regards
ASHFAQ