How to do sum of column(Total profit) by Region in excel file

[ppr (Peter Preuss)]

do fixing like described here:

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

remove all unneded activities
open build datatable activity and also remove all lines (one is havein text in first column)