Total Sales value per Cusomer issue..... 1

[AuctionLamb]

Hi guys!!

Me again.....need your help on a calculation problem I am having.

I have many Customers with CreditAmounts. I group my Customers to give me one Customer per line. How do I calculate the CreditAmounts allocated to that Customer?

For example I have 10 records selected, 4 records are from Customer A and rest are one record per unique customer. The report groups my Customers to one unique Customer, so that 4 records will show Customer A but will have 4 different CreditAmounts to it......how do I show that CreditAmount total for that 4 records into one record with the groupname of Customer A?

Help need urgently over here......THANKS GUYS!!!

 

[AuctionLamb]

I am working on CR 8.5

 

[Madawc]

Right-click on a field and choose Insert to get a choice of Running Total or Summary.

Summary will give you a choice of Sum, maximum or minimum, whichever it is that you want. You'd be able to select it for the group.

Madawc Williams (East Anglia, UK)

 

[AuctionLamb]

THANKS Madawc!