Variance report using a baseline: How?

[bwschiek]

Hi:

I need to create a report that uses a line graph to show the year to year variance (as a percentage) of number of sales using the first years numbers as the variance. In other words, years will be on the horizontal axis and the vertical axis will be percentage.

Here is a quick example:
# of sales %Variance
1999 10 100%
2000 5 -50%
2001 13 130%
2002 20 200%

I have four years worth of data. I want 1999's data to be the baseline, so the graph will show that 1999's number of sales and dollar amount of sales will be equal to 100%.

Any ideas?

Thanks in advance!

 

[MColeman]

Could you use a Chart in Crystal?

 

[bwschiek]

Hi:

Yes, I am trying to use a Crystal Chart. Sorry if it sounded like I was trying to do this outside of Crystal.

Thanks.