Subtotals in a crosstab query

B

Bob

I would like to know if there is a way to do sub-totals in a crosstab query.
I would like to have multiple sub-totals by Location name, Salesrep and
Region.

Thanks.
 
D

Duane Hookom

Are subtotals a combination of multiple columns or multiple records? Assuming
you by subtotals by multiple records, you can easily do this in a report. If
you don't want to use a report, you can union multiple crosstabs together.
 
Top