Average in report based on crosstab query

[LVer]

I created a report based on a crosstab query that lists all the charges per
terapist (rowheads) ordered by month (columnheads) for one year. At the end
for every therapists line, I would like to have a field calculating an
average for the year, even when the year is not yet over. Can anybody help me?
Thanks.

 

[Allen Browne]

Add the value field again, with RowHeading in the Crosstab row, and Avg in
the Total row.

 

[LVer]

Thanks for your fast answer. But the problem is not yet solved. For some
reason it gives me an average for all the daily entries in the month and not
for the the sums of the entries per month over the year. I realy want the
average for the 12 months of the year.