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]