Average horizontal line on hte Bar Chart

[dzavad]

Hi,
I am working on the Monthly Trend for Facility report and I need to add a horizontal line to the bar chart to show the average number of falls per month for the entire facility, based on the date range . I am using cr 10 or 11.
I cant seem to find the way to do this dynamicaly. I can do this manualy by creating Average formula like this:
Average([sum({@april}),sum({@august}),sum({@december}),sum({@february}),sum({@january}),sum({@july}),sum({@june}),
sum({@march}),sum({@may}),sum({@november}),sum({@october}),sum({@september})])
but it doesnt work with the date ranges and across the years.
Any idea what am I missing here

 

[lbass]

In the chart expert, what are you using as "on change of" and "show value" fields? What is the content of one of your formulas, e.g., {@April}?

-LB