I have a Data Table as below:
What I would like to find out is the sum of all Invoice Values corresponding to a Client Name. So the output should be like below:
<ClientName 1>:Total Invoice Value
<ClientName 2>:Total Invoice Value
and so on.
How shall I get this done. Kindly help.