Summing Grouped Items

[slr22]

I have a report that is grouped and I need to be able to take those grouped items and get a total. I have a product and then grouped within that I have warehouse and direct and within that I have each division that has sold that product. I want a total sales of warehouse and direct for each division under what I already have.

For example:

Sales
Product Name
Warehouse
A $1.00
B $3.00
C $5.00
Warehouse Total $9.00
Direct
A $3.00
B $3.00
C $1.00
Direct Total $7.00
Product Total $16.00

Below this I want for each product a total for each A,B,C.

Example:
A $4.00
B $6.00
C $6.00
Total $16.00

Since I have it grouped by product, then warehouse/direct, then division, I don't get a total for each division by product. Is there a way to do this?

Thanks,
Sandy

 

[synapsevampire]

You can either use a subreport or a crosstab for this, the crosstab might be the easiest if you don't have elaborate formatting requirements.

-k

 

[slr22]

I tried the subreport, however I have multiple products and I wasn't quite sure how I was going to put that total in the middle of each product. When I do the subreport it puts all the products in that area and I need them between each product. Do you have any suggestions?

Thanks,
Sandy