Creating multiple series in a chart

[Groancold]

I've got a date field for sales in our CRM database. I'm trying to create a line graph that shows the monthly sales for 2005 and 2006 as two seperate series.

Using Crystal IX, I've been able to get a chart that shows the monthly sales summary but it starts at jan 2005 and shows every month until july 2006 (instead of showing 2005 as one line and 2006 as the other). I did this using the chart expert to use the date sold field and "show by month" whilst creating a formula that summarizes all the amount sold fields.

Can any one point me in the direction to create this as two seperate series of data?

Thanks

 

[lbass]

Try using a formula for month for the "on change of" field:

monthname(month({table.date}))

After adding this to the chart expert, highlight it->order and choose specified order, and arrange the months in chronological order.

For "show values" (the lines) use formulas like:

//{@2005}:
if year({table.date}) = 2005 then {table.amt}

//{@2006}:
if year({table.date}) = 2006 then {table.amt}

-LB