Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have bar graph grouped by the field 'commenced quarter'.
The quarters are July-Sept 2019, Oct-Dec 2019, Jan-March 2020.
How do I create an expression to sort the grouping to the above order? It is currently in the order July-Sept 2019, Jan-March 2020, Oct-Dec 2019.
Thank you
Assuming all your month reference would be of MMM format (three-letter), you could try like:
=Date#(QtrField, 'MMM-ZZZ YYYY')
Assuming all your month reference would be of MMM format (three-letter), you could try like:
=Date#(QtrField, 'MMM-ZZZ YYYY')