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!

Register Log in
  • 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!

Summing Grouped Items

Status
Not open for further replies.
slr22

slr22

MIS
Jun 26, 2002
80
US
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


 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Wolffen
  • Locked
  • Question
Help: Summing a group field
Replies
3
Views
39
Naith
Naith

Part and Inventory Search

Sponsor

Back
Top