Grand Total Summary/Average in Cross Tab

[eizatt]

COLUMN 1 CLOUMN 2 COLUMN 3 TOTAL
36 41 94 171
12 16 35 63
1 2 5 8
23 23 54 100
3.91 2.24 3.89 10.03
2.50 1.25 2.23 5.98


I need help to find if different rows of a cross tab can be summarized differently in the grand total. In the table above the first 5 rows all summarize in the total, the last 2 rows need to be an average of the 3 columns. 10.03 should be 3.35 and 5.98 should be 1.99. Is this possible.

Thanks,
Ed

 

[AmunRa]

The onyl way you could possibly do this would be to write 1 report that had the grand totals in the cross-tab and suppressed the other row. Then a second report that only showed the average rows. Then pull the two together, one being a sub-report. There would be some alignment work to be done.