Cross Tab Sub Total

  • Thread starter Thread starter Natalie
  • Start date Start date
N

Natalie

I have a report that is based on a cross tab query. the column headings in
the query are dates. I have grouped the report by States and region. I
would like to do a subtoal by state and region and also a report total.

How can I set the text box in the group footer to sum each value column?
 
I would set up the report using the solution found at faq703-5466. You would
need to substitute your date interval for Months.
 
Back
Top