Table Summary totals for dataGrid using DynamicModel

How might I create totals for each numeric column on a dataGrid created from dynamic data?

public class CustomAggregate : ISummaryAggregate  {      public CustomAggregate()      {      }      public double DynmaicValue { get; set; }      public Action<System.Collections.IEnumerable, string, PropertyInfo> CalculateAggregateFunc()      {          return (items, property, pd) =>          {              var enumerableItems = items as IEnumerable<DynamicModel>;              var collection = new ObservableCollection<double>();              foreach (var item in enumerableItems)              {                  var dict = item.Values.Where(x => x.Key == "OrderID");                  foreach (var value in dict)                  {                          collection.Add(double.Parse(value.Value.ToString()));                  }              }              if (pd.Name == "DynmaicValue")              {                  this.DynmaicValue = collection.Sum();              }          };      }  }    //Adding Table summary to the row.  GridTableSummaryRow summaryRow = new GridTableSummaryRow();  summaryRow.Title = "Toal : {TableSummary}";  summaryRow.Position = Position.Top;  summaryRow.ShowSummaryInRow = true;  summaryRow.SummaryColumns.Add(new GridSummaryColumn  {      Name = "TableSummary",      CustomAggregate = new CustomAggregate(),      MappingName = "OrderID",      Format = "{DynmaicValue}",      SummaryType = Syncfusion.Data.SummaryType.Custom  });  grid.TableSummaryRows.Add(summaryRow);

Thanks very much for the code sample. I notice that you are hard-coding the field name 'OrderID'. In our case, we don't know the name of the fields that we want to aggregate before runtime. We download JSON data and parse it into a DynamicModel for this reason, and then loop through each element in the first 'row' of data in order to add the columns. We also need to sum more than one column. Our JSON field names are preceded by 'dec' for decimal or 'str' for string, to save having to parse the values to check what type they are.

Pradeep,