Crosstab Qry-Add Rows & Columns

[Guest]

Hi,

I have 4 fields in a crosstab query.

FIELD = CROSSTAB
Product Name = Row Heading
Retailer Name = Column Heading
Item Quantity = Value (Sum used in Total)
Item Quantity = Row Heading (Sum used in Total)

Result shows orders for each Product Name by each Retailer and get complete
Total for each product on the rows.

I want to get a total for each Retailer for the columns. All the products
that each Retailer orders should add in the column for each Retailer.

Any idea how to do that?
Many thanks, in advance.

 

[Guest]

You can't include a row at the bottom of the table for column totals (if
that is what I think you are thinking!). You can use the cross tab as the
source for a totals query.

 

[Guest]

You can use the running sum in a report to total columns.