If there are multiple rows for the same condition, then sum up values of different columns

[T_Lina]

Hi, 

could someone help me with the following challenge?

For wherever the ID is the same, I would like to add up the quantites and values as shwon in the "expected output".

I tried the summarize tool but wasn't successful unfortunately. 

Thanks a lot!

[OllieClarke]

Hi @T_Lina can you elucidate on how the summarise tool didn't work? It worked fine when I tried:

[T_Lina]

Thank you, @OllieClarke !

I made the mistake by not putting both fields as action "sum" but "group by". 

Now it works as you've shown in 🙂