I have a report that performs a calculation in the summary band. The calculation is sum(max_credit) - sum(sales_amt). There is a one to many relationship between Max_Credit and Sales_Amt. Max_Credit is at the Customer level and the Sales_Amt is at a lower level. Meaning that a straight sum(Sales_Amt) will work but I only want to sum the Max_Credit when the Name changes - for each unique name.

How is this accomplished?

Name,Max_Credit, Sale_Amt
smith,1000.00,50.00
smith,1000.00,75.00
johnson,2000.00,35.00
taylor,500.00,25.00
taylor,500.00,55.00