Sum value base on value at another column on datatable

Hi Everyone.

I have a datatable as excel file.

I want to sum “Amount” column base on same value at “ID” column and return result into C column.

How to do that ?

Thanks in advance!
Book1.xlsx (8.2 KB)

If you want to group by and sum, you can use ‘Group By Aggregation’ activity (Download Package: BalaReva.DataTable.Activities).
This return the result as key and sum value.

1 Like

find starter help here:
GroupBy_Sum_1Col.xaml (7.9 KB)
GroupBy_Sum_1Col_SumColAdded.xaml (7.7 KB)

1 Like

Thanks you all of you!

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