Subtotals in a crosstab query

[Guest]

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.

 

[Guest]

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.