Group by row value and sum of the column values

[vinothdeva]

How do i group by a row value and find the corresponding sum in column values.

Input:

A	1	2
A	10	4
B	2	5
B	4	7

output

A	11	6
B	6	12

[haroon_sa · Accepted solution]

Hey @vinothdeva

Summarize is the tool ,for your problem....

here I've attached workflow

[jmarsch]

I am trying to do something very similar to this.  However, it does not sum all the rows in the fields I am grouping by so the sum is less than it should be.  Any ideas on what is wrong?