Skip to Content
Former Member
Jul 28, 2008 at 12:15 PM

Crosstabs not averaging correctly


I am using crosstabs in a report that lists students and the grades they received per course. Crosstabs allow me to list the students in a column format.

The first column header says average and this is where I wish to calcutale the averages of the students grades per course. However, it seems that I can get it to average the grades but only per page rather than for the entire group. I have three pages and I need the students listed on all three pages to be included in the average and this average listed on all three pages. Currently what I'm getting is each page of students is being averaged seperatey therefore each page is showing different averages. I've researched crosstabs and still don't know how to make that work or even if it is possible.