Average in graph

[#1]

Hi,

I am trying to show the avergae Incident Rate in the column for the Qlikview attached. I have worked out the incident rate and I know that the average is 3.01, I want this showing in the right hand column.

The trendline function will not suffice here as I need to use the average for some other calcuations. Please help???

Dave

[johnw · Accepted solution]

This?  "Total" tells it to ignore your dimension values.

12*sum(total [CM Tickets])/sum(total Population)

[#3]

John,

Had to tweak it slightly but works a treat. This total function will enable me to do a few reports