Totalling Rows and Columns in a Crosstab Query

[Alberto]

I have created a crosstab query that has:
Column Headings: Month 1, Month 2, Month 3, etc.
Row Headings: Salesperson 1, Salesperson 2, Salesperson 3, etc.
Field: DollarValueOfSales

I have successfully been able to sum up the Dollar Value of Sales over the
entire period with a Column entitled Total that is at the end of the Crosstab
query. However, I have not been able to sum up all of the sales in a given
month across all of the salespeople.

I don't know if this matters, but my dates are dynamic.

 

[Duane Hookom]

You have a couple options:
1) display the totals in the footer of a report section or form
2) create a similar crosstab with a constant for the Row Heading. Create a
union query based on the 2 crosstabs.