Calculate same name (1 Viewer)

[mtp]

My report shows that broker in sorting by broker's name and 1 broker can have many clients. I got problem when doing sum for any client have the same name and same id. Do I have to make a new query? Or should I go to report design and do something which I don't know how to do yet. Any help is very appreciated. Thanks

 

[KevinM]

The client should only appear ONCE or does each Broker share the same clients?

How is yout table and report structure & relationships set up?