Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Really easy question I'm sure.
I'm looking to sort Months but using the sort expression however my months are text (and need to remain as text). What is the expression I need to write? Jan 11, Feb 11, Mar 11, Apr 11, May 11, Jun 11 etc
Thanks
Try to sort by loading order
Sort Tab
Use Below Expression
=Date#(MONTH,'MMM YY')
Properties-->Sort-->Numeric Value-->Ascending