Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
can any one let me know i want to sort Months.. it should come in this way..
Jan, feb,mar...till............dec.
but in my case it is not coming even by expression
if(Month= 'jan',dual('Month',1),
if(Month= 'feb',dual('Month',2), and so on
can any one help me in this?
regards
ABhay
sort by expression :
=only({1}num(Month(Date#(Month,'mmm'))))
Sry prem its not working
try this
=only({1}num(Month(Date(Date#(left(Upper(trim(Month)),3),'MMM')))))
or else post sample app
Hi Abhay,
Order the dates in the script itself and select Load Order in Sort tab, always use master calendar. Check this link
I think you need to do two things to accomplish your requirement.
1. Load your data with enumerated month labels
2. Sort the expression by number
This will make your data clearer and the front end work much easier.