Group by and sum

Help
1

Hello Guys,

i had the following datatable 'data":

image

i want to sum the colymn2 by group related to the column1:

i tryed the folowing linq;
data.AsEnumerable().GroupBy(Function(row) row.Item(“Column1”)).Select(Function(group) New With {.Grp = group.Key, .Sum = group.Sum(Function(row) Double.Parse(row(“Column2”).ToString()))}).CopyToDataTable()

error is: CopyToDataTable() is not a member of AsEnumerable( of type unknown)

2

try this

Main.xaml (9.9 KB)
Main.zip (2.3 KB)