Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.