I have a crosstab report that is displaying the # of crashes and calculating a Rate of crashes per day based on the month and severity. The report looks okay except for the columns total (Severity) for rate per day and total/total rate per day are totals instead of calculation. See Attached file
The Rate per day is calculated based on the # of crashes / # of days in the month. In the total column instead of a calculation it is doing a total.
I also need to display the # of days in the year which is a total of the # of days per month.
The package is a DQM package