Group By, Sum

[#1]

Hi,

Appologies for the simple (I think) question. And i cant find an answer from the forum so far.

I have a number of fields (6) of which one is a customer number, another is an outstanding balance field. Now one customer number can have several outstanding balances. What i would like is to have the customer number appear only once, with the total of all the outstanding balances showing rather than duplicate customer numbers.

Am i right in thinking that i should be using the Group By or the Sum function?

This is how my script looks at the moment:

LOAD

Absolute_Balance

BP

Dunning_Level

Dunning_Procedure

Last_Payment_Received_Date

CA

FROM

WHERE

Many thanks.

EXISTS (BP) ; (qvd )

[#2]

Hi,

first try to create a pivottable and see if this is what you are looking for.

Good luck!

Rainer