Many of you may not know that you can bring a numeric field into the Summary Field Window more than once. A field may be brought in and calculated in 10 different ways.
Your results may be produced using the Ratio option.
The two Summaryfields are "Quantity" and "Amount". They are being SubTotaled on a value change of a Keyfield, "Department".
You would now like to divide the "Amount" by the "Quantity" to arrive at a price for each item per Department.
Edit your Summary Definition, bring the "Amount" field into the Summaryfield box again (by Default this field will be calculated by Average). Double click to bring up the Properties. Uncheck the Use Dafault Title box and name the field "Each" (or whatever you like). Click on the Calculation Tab and choose the Ratio option, in the drop down choose the "Quantity" field. OK on all windows.
This will create a new field displaying the results of amount of each item per Department as well as a result for the SubTotaled amounts for each Department.
I hope this is helpful,