How to convert a table to pivot table with sum of a particular column

[MAHESH1 (MAHESHKUMAR JV)]

@jamnanin
You can group by based on DepartMent column.
For grouping and take the sum refer this post

How do I group by one column in the datatable and take the sum?

@jamnanin I will suggest you one more way try like this. Let us take your excel stored in a datatable dta First group the datatable based on ID by using below Query and assign it to dt1 dt1=(From p In dta.Select() Group p by ID=p.Item(“ID”).ToString Into Group Select Group(0)).ToArray.CopyToDataTable() Now take only two columns by using below query dt1=dt1.DefaultView.ToTable(False,“ID”,“Name”) Now Add one datacolumn to dt1 by using add datacolumn activity and give name Amount to that c…

creating new datatable after grouping and taking sum of each group.
Now to take the sum of that particular column refer the below post

Issue with the sum in excel

Hi, @Braki instead forloop you can use LINQ. use below code to get sum of the column Convert.ToString(BaseTotal.AsEnumerable().Sum(Function(row) row.Field(Of Double)(“Importes”))) for each.xaml (39.4 KB) use this xaml file @Braki Regards, Arivu

Regards,
Mahesh