Find sum of values by grouping in a Data Table

Help Studio
,
1

Hello All,

I have a Data Table as below:

Capture

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.

Regards.

2

@suryasunderraj
find some starter help here:
GroupBy_Sum_1Col.xaml (7.9 KB)

3 Likes
3

@ppr - Thanks. :v: Is this advanced coding that is used ??

4

@suryasunderraj
it is just combining some standards. Have look here:

However was the provided demo matching your requirements?

5

Yes. Sum by grouping is what i wanted. :slight_smile:

6

@ppr I am new to coding. Just aware of the basics. Guess I need to pick up more !! :roll_eyes:

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.