cfchart clustered bar chart

[gogl]

i have a query with the following fields - curYear :Number, pcsa : String,
rate : Number.

the data looks like:
curYear - pcsa - rate
2003 - east - 4.52
2003 - west - 4.3
2003 - central - 5.1
2004 - east - 3.5
2004 - west - 4.61
2004 - central - 3.7

and so on...

what i am trying to do, and have had no success with so far, is to create a
clustered bar chart with the years as the main itemcolumn on the x axis, and
the pcsa beging the bars(veritcle) on the chart.

i have tried a number of things, but none of them seem to get the job done.

this:

gives me the years going across the bottom, but only on bar for each year....
no clustered pcsa.

this:


<cfchart format="flash" title="PCSA Comparison for #measure#"
seriesplacement="cluster" sortxaxis="yes">
<cfoutput query="repYearData" group="pcsa">
<cfchartseries type="bar" query="repYearData" itemcolumn="curyear"
valuecolumn="rate"/>
</cfoutput>
</cfchart>

[gogl]

doh!. posted instead of previewed.
anyway.
this first bit of code (missing from the original message) should have been:

<cfchart format="flash" title="PCSA Comparison for #measure#"
seriesplacement="cluster" sortxaxis="yes">
<cfchartseries type="bar" query="repYearData" itemcolumn="curyear"
valuecolumn="rate"/>
</cfchart>

the second bit of code... the one showing in the original message show s the
years, but obviously with all of the bars in it for all the pcsa.

i've tried some queries of queries to loop thru, and have gotten close, but i
am now thinking that i am missing something, because it seems that it should be
simpler than this.