Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Sort expression on bar chart

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 

 

 

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Assuming all your month reference would be of MMM format (three-letter), you could try like:

 

=Date#(QtrField, 'MMM-ZZZ YYYY')

View solution in original post

1 Reply
tresesco
MVP
MVP

Assuming all your month reference would be of MMM format (three-letter), you could try like:

 

=Date#(QtrField, 'MMM-ZZZ YYYY')