Sorting Y-Axis on Chart (Years and Months)

[#1]

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)

• year_index (1,2,3,4)
• montth_index (1-12)
• Month (Apr, May....Mar)
• Year (2010/11, 2011/12, 2012/13)

What ever I do to try and sort the y-axis - nothing seems to work.

Any help appreciated.

Fiorano

[#2]

Anyone?

[khadeer]

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.

[khadeer]

=match(Month,'Apr','May','Jun','Jul','Aug','Sep'.......'Mar')

it will help u

[#5]

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...

[nagaiank · Accepted solution]

Youmay try using the sort expression

year_index & month_index

[#7]

Thanks!