I'm trying to develop a report that contains an average for a subset and the average for the entire group.

Test scores for example: Classroom average and school average.

Can I get them both to appear in the same band in a report?

Run queries to prepare each result. Put indexes on each and put them in the data-model of a report. The summary figures come from the (one-record) master.