sum

[joelle_alhanna]

hi,

I have the following question

I want to get the salesman related to a client but showing the sales of these salesman regardless of the client

for  example:

Client 1 - Salesman1 - Sales 100

Client 1 - Salesman2 - Sales 200

Client 2 - Salesman1 - Sales 500

I want to show the following

Client1 - Sales 800

Client2 - Sales 600

any help please

[edwin]

What are the rules though?  it looked like you credited the sales for Client2 to Client1 but not the other way around.  what if there are 3 clients?  how will QV know which clients to aggregate and which ones not to?  you need to supply the rules as it cant be guessed at

[joelle_alhanna]

one client can be related to multiple salesmen.I want to add the total sales of these salesmen and assign it to the client.