Average in report based on crosstab query

[Guest]

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.

 

[Guest]

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.

 

[Allen Browne]

You have a row for each therapist, and a column for each month.
You can get the therapist's total across the months as a row heading.

If you wanted the total for the month at the foot of each month's column,
create a report based on the crosstab, and put the text box in the Report
Footer section to show the column totals.

If the problem is that some months have not occurred yet, so the months
don't appear, use the Column Headings property of the query to enter all 12
months. Since they are then in the query-whether they have data or not-you
can build the report for the 12 months and the columns will be present.

 

[Guest]

Thank you Allen,

There were two problems to solve, one you gave the answer to. The other was
solved when I discovered I had not yet made a sum per month in the pre-query.
Thanks again.