Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Im having trouble sorting my y-axis on a chart. Im my dataset I have the following date identifiers :
(Years are Financial Year - Apr-Mar)
What ever I do to try and sort the y-axis - nothing seems to work.
Any help appreciated.
Fiorano
Anyone?
In sort tab go to expression in that write by using match r wildmatch function it will work.
Give some sample data i will write expression.
=match(Month,'Apr','May','Jun','Jul','Aug','Sep'.......'Mar')
it will help u
Hi this does help when viewing a single financial year. When I deselect the year filter the Months and financial years are combined eg Apr-2010, Apr-2011, Apr-2012, Feb-2010, Feb-2011 etc...
Youmay try using the sort expression
year_index & month_index
Thanks!