Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Totals in columns of a crosstab 1

Status
Not open for further replies.

gruposenda

Programmer
Jan 11, 2007
51
MX
Hi:
In a crosstab there are columns Region #1, ...,Region #5, and in each one appear 2 measures (miles and liters).
Can I get a total by each one of the measures at the end of the report ?
Thanks in advance
 
I would not try to incorporate the total values somewhere in the crosstab itself. (will be a bit messy)
Why not place a small list at the end of the report that displays the grand total of each of the measures (and bias this list against the same query minus the dimensions that you do not want to incorporate)

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top