Overall totals in a crosstab query

[kupe]

A crosstab query gives the totals for students in particular classes per the Class they belong to, i e

College A – Class1 4, Class2 12, Class3 17
College B - Class1 12, Class2 124, Class3 12
College C - Class1 5, Class2 16, Class3 7
College D - Class1 4, Class2 13, Class3 9
Etc etc

Experts, is there a way to an overall total of the lot, ie


Class 1 30, Class 2 48, Class 3 28, Class 4 etc etc

please?

 

[kupe]

Much obliged to you, Pat. All the best.