I have created a simple log application, in one form field I store the time (in hours) and in another store the number of successful events (Number).

In the form I have a calculated field (Events / Time) giving the number of events per hour for the individual line records, I am looking for the ability to calculate the total average events per time from the sum of  events and sum of time in the pivot report across all filtered records

Any idea’s?