Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I have a custom order to a listbox with months

I have created script to give me the month from Application date, which is now entered as a field in a general listbox on a dashboard.

Is there a way I can re-order this so that it is not in calendar month order?

I need it to show based on my financial year which begins in August.

Any help greatly appreciated, either by creating fields in script or simple option checking.

Rob

1 Solution

Accepted Solutions
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi

Yes this is possible

What I will do is right click on the chart > Properties > Sort > check the box beside Expression & click on Expression > click on ecclipse (...) then type 

=Match(DIMENSION NAME,'Aug','Sept','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul')

Click ok.

View solution in original post

1 Reply
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi

Yes this is possible

What I will do is right click on the chart > Properties > Sort > check the box beside Expression & click on Expression > click on ecclipse (...) then type 

=Match(DIMENSION NAME,'Aug','Sept','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul')

Click ok.