System.Activities System.Activities.Statements System.Activities.Expressions System.Activities.Validation System.Activities.XamlIntegration Microsoft.VisualBasic Microsoft.VisualBasic.Activities System System.Collections System.Collections.Generic System.Data System.Diagnostics System.Drawing System.IO System.Linq System.Net.Mail System.Xml System.Xml.Linq UiPath.Core UiPath.Core.Activities System.Windows.Markup GlobalVariablesNamespace GlobalConstantsNamespace UiPath.Excel UiPath.Excel.Model System.Collections.ObjectModel UiPath.Excel.Activities.Business System.ComponentModel System.Runtime.Serialization System.Xml.Serialization UiPath.Excel.Activities System.Reflection System.Activities Microsoft.VisualBasic System.Private.CoreLib System.Data System.Data.DataSetExtensions System System.Drawing System.Core System.Xml System.Xml.Linq System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities UiPath.Studio.Constants UiPath.Excel.Activities.Design UiPath.Excel.Activities UiPath.Excel System.ObjectModel System.ComponentModel.EventBasedAsync PresentationFramework System.ComponentModel.TypeConverter WindowsBase Microsoft.Win32.Primitives System.ComponentModel System.ComponentModel.Primitives System.Private.ServiceModel System.Runtime.Serialization.Formatters System.Private.DataContractSerialization System.Runtime.Serialization.Primitives System.Private.Xml System.Data.Common System.Reflection.DispatchProxy System.Reflection.TypeExtensions System.Reflection.Metadata True True [dtFinal] [dt1.Clone] False False [dtFinal] [( From table In dt1.AsEnumerable Where Not table("Year").ToString.Contains("Total") Group table By Year = table("Year").ToString, Month = table("Month").ToString Into grp = Group Let sum1 = grp.Sum(Function (x) CDbl (x("Sum").toString.Trim)) Let Count1 = grp.Sum(Function (x) CDbl(x("Count").toString.Trim)) Select dtFinal.Rows.Add({Year, Month, sum1, Count1 }) ).CopyToDataTable]