Summing outside of group

[sabobas]

This may be difficult to explain as I do not use Crystal often.

Brief description of the desired report:
A customer with different locations(custid's) is given aggregated prices based on the combined product order quantities of each product. Our billing system is not capable of doing this calculation. I have been able to create the pricing formulas for various qty thresholds and using running totals in the groups I can calculate the correct price IF I group by product.

I would like to create a less detailed report that is not grouped on product, but still has the correct updated prices. If I change the grouping to anything other than product, my running totals look up the prices on all products, not each particular product.

Example desired report:
Custid, ProductId,Qty,Recalculated Price,RecalculatedCharge

Any advise for getting started would be helpful.




Pricing Formula:
IF {monthlysummary.productid} = "STD WIDGET"
THEN
IF Sum ({monthlysummary.eventcount},{monthlysummary.productid})>5000 THEN .30 ELSE
IF Sum ({monthlysummary.eventcount},{monthlysummary.productid})> 1000 THEN .36 ELSE .50
ELSE
IF {monthlysummary.productid} = "MINI WIDGET"
THEN
IF Sum ({monthlysummary.eventcount},{monthlysummary.productid})>5000 THEN .20 ELSE
IF Sum ({monthlysummary.eventcount},{monthlysummary.productid})> 1000 THEN .26 ELSE .40

Etc.

 

[sabobas]

I don't know how to edit my post, but I am using Crystal 6.0