Hiya, I have some text fields denoting Periods in my data set. These are labels as follows:
Pre-Project
Q1 2012
Q2 2012
Q3 2012
Q4 2012
Q1 2013
I would like to custom sort them to they are in above order - but at present they won't do this (and either just go in load order or Q1 2012, Q1 2013 etc). Is there an expression I can use to sort these?
It would be best to correct this in the script, by parsing in your periods as dates. dates have a numeric representation which you can use for sorting.
In the list box properties, you can also try a sort by expression:
It would be best to correct this in the script, by parsing in your periods as dates. dates have a numeric representation which you can use for sorting.
In the list box properties, you can also try a sort by expression:
