30 Apr 12 14:18
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
'12 and under'
age in 13 to 18
'13 to 18'
age in 19 to 49
'19 to 49'
'50 and over'
FISCAL YEAR GROUP sorted in ascending order
if add_date in date(2009,07,01) to date(2010,06,30)
add_date in date(2010,07,01) to date(2011,06,30)
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
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.