Multi Year Comaparision charting

[Thant]

Greetings,
I have a table in my database which lists the following data
year (date/time)
Total Rx's (number)
Avg Rx / day (number)
Acq cost per rx(currency)

What I am trying to acomplish is a chart that shows the first quarter of 2010 compared with the same data for first quarter 2009. I would like it to be in the same chart. I know there is a stacked line chart but im not sure how to group or show my data to show the comparison.
Any ideas would be helpful
Thanks

 

[lbass]

If your data is already summarized in the table at the year level, you will not be able to break out quarters.

-LB

 

[Thant]

It is not. It is entered monthly, therefore I know I can break it out by quarters but the biggest problem is im not sure how to show 1st quarters of 2009 and 2010 in comparision on the same chart
Thanks in advance

 

[lbass]

You are showing a field "Year (date/time)". I need to know what you are working with for dates. Is there a datetime field that has a datatype of datetime?

-LB

 

[Thant]

If I understand you correctly the answer is yes.
I have a field in my database which is called Date
It lists data as mm/year (01/2007) It value in the design field is listed as Date/time (short date)
Is this what you are looking for?

Thanks

 

[lbass]

You should use a record selection formula like this:

{table.date} in date(year(currentdate)-1,1,1) to date(year(currentdate),3,31) and
datepart("q",{table.date}) = 1

This will return data for the first quarter of each of the current and previous year. Then you can use {table.date} as your "on change of" field in a line chart. While it is selected->order->print on change of year. Then add your three summary fields.

-LB