Hi Folks
** Sorry but I posted this in the Crystal Reports 1 Formulas Forum yesterday but think this is a better forum for it. **
Here's an excerpt of the data I'm using in my chart:
Place Value
Site1 10
Site2 15
Site3 16
... ..
Each 'Value' is a formula field and is simply a total of all values for that 'Place' e.g. for Site1 there are 3 values - 4 + 5 + 1 = 10.
The chart shows a 'Value' for each change of 'Place'. However I'd also like to include either a line running the whole width of the chart to show the average of all 'Value's or a separate 'Place' entry (called 'Average') showing the average.
Is this possible? There doesn't seem to be a way to add an average value to a chart.
Cheers!
** Sorry but I posted this in the Crystal Reports 1 Formulas Forum yesterday but think this is a better forum for it. **
Here's an excerpt of the data I'm using in my chart:
Place Value
Site1 10
Site2 15
Site3 16
... ..
Each 'Value' is a formula field and is simply a total of all values for that 'Place' e.g. for Site1 there are 3 values - 4 + 5 + 1 = 10.
The chart shows a 'Value' for each change of 'Place'. However I'd also like to include either a line running the whole width of the chart to show the average of all 'Value's or a separate 'Place' entry (called 'Average') showing the average.
Is this possible? There doesn't seem to be a way to add an average value to a chart.
Cheers!