Grouping by multiple fields

[csmalls]

Hi!
I am creating a report in which I need to create total sales base on three criteria - Account #, Job #, and Dept.
I need to show total sales when each of these criteria are unique.
For Example
Acct # Job # Dept
554677 QW345 3489 $75
554677 QW345 3489 $25
554677 QW345 7684 $560
554677 QH478 7684 $95
554698 QH478 3489 $15
554698 QH478 3489 $85
554698 QW345 7684 $100


The report should end up looking like this:

Acct # Job # Dept Total Sales
554677 QW345 3489 $100
554677 QW345 7684 $560
554677 QH478 7684 $95
554698 QH478 3489 $100
554698 QW345 7684 $100

Right now, since some of the criteria are the same in each list, my sales are now totaling incorrectly. I have tried every sort order and grouping order/combination I can think of and I end up with this (or something similar):

Acct # Job # Dept Total Sales
554677 QW345 3489 $755
554698 QW345 3489 $200

Basically, whatever I end up with as the first group criteria is there once with all sales for that group and the other two group functions having no real relevance.

Until, today I considered myself an intermediate user, but this is really stumping me.
We were using Access for this report, and I simply used the group function. I am being required to move all reports to a Crystal Reports platform and I am stuck on this one.

I would appreciate any assistance and feedback.
Thank you!

 

[lbass]

Insert groups on fields in this order: Acct#, Job#, Dept. Right click on sales in the detail section and insert a sum at the Department group level. Then drag all groupnames into the Department group footer next to the inserted sum. Then suppress all other sections.

-LB

 

[csmalls]

lbass -
Thank you!
This is exactly what I needed. I appreciate your help.
-CSMALLS