I have a grouping Age and then Fiscal Year but the sorting is not correct on the bar chart and the only thing I can figure is because there is no data for ages 12 and under in fiscal year 2009-2010. There are data for ages 12 and under in fy 2010-2011 and all of the other age groups has data for both fiscal years.

I have the bar chart on change of age group then fiscal year group.

AGE GROUP sorted in ascending order

if
age<=12
then
'12 and under'

else if
age in 13 to 18
then
'13 to 18'

else if
age in 19 to 49
then
'19 to 49'

else if
age>=50
then
'50 and over'

FISCAL YEAR GROUP sorted in ascending order

if add_date in date(2009,07,01) to date(2010,06,30)
then
'2009-2010'
else if
add_date in date(2010,07,01) to date(2011,06,30)
then
'2010-2011'

AGE RESULTS

12 and under
no data for fy 2009-2010
1 for fy 2010-2011

13 to 18
100 for fy 2009-2010
106 for fy 2010-2011

etc.

PROBLEM

My bar chart shows the ages 12 and under for fy 2010-2011 as 1; ages 13 to 18 and other groups are showing 2010-2011 first so for ages 13 to 18, the first bar has 106 then the second bar 100 for this age group.

I need the first bar to have the fy 2009-2010 data then the second bar to have the 2010-2011 data.

I hope I gave enough information. Help is very appreciated.

thank you