Hi you can try with this approach.
From row In dataTable.AsEnumerable()
Group row By CustomerName = row.Field(Of String)(“CustomerName”) Into Group
Select New With {
.CustomerName = CustomerName,
.TotalSales = Group.Sum(Function(row) row.Field(Of Double)(“SalesAmount”))
}
dataTable - Read Range Output
Steps
- use Read Range and create the OP
- Use assign ( var type- DataTable )Activity & pass the query
- Use write range activity & write the output