I am trying to create a running weekly average based on the Total in a Crosstab, but can't figure it out.
(I had originally posted this with a different type of average, and now this has been corrected!)
The average would be calculated by the number of weeks, rolling forward as new weeks are added to the report. (Running Total of
Appointment Counts/Number of weeks)
Example: (see table)
1st week: 4/1 = 4
2nd week: 6/2 = 3
3rd week: 10/3 = 3.3
4th week: 20/4 = 5
And so on, for each upcoming week...
Any help is greatly appreciated!