Total Summary

8/25/2015 Germany Rössle Sauerkraut $45.60 15
8/25/2015 Germany Chartreuse verte $18.00 21
8/25/2015 Germany Spegesild $12.00 2
10/3/2015 Germany Vegie-spread $43.90 20
10/13/2015 Germany Aniseed Syrup $10.00 6
10/13/2015 Germany Lakkalikööri $18.00 15
1/15/2016 Germany Raclette Courdavault $55.00 15
1/15/2016 Germany Original Frankfurter grüne Soße $13.00 2
3/16/2016 Germany Grandma's Boysenberry Spread $25.00 16
3/16/2016 Germany Rössle Sauerkraut $45.60 2
Count: 2155
Sum: $56,500.91

Our Blazor Data Grid can compute summaries (using aggregate functions such as Sum, Min, Max, etc) for both the entire contents of the grid and at each individual group level. “Total” summaries are calculated across all grid records and displayed within the grid’s footer. To create total summaries, add DxDataGridSummaryItem objects to the TotalSummary collection.

Key DxDataGridSummaryItem properties are summarized below.

  • SummaryType – Specifies the aggregate function (Sum, Min, Max, Avg, and Count) used.
  • Field – Specifies the name of the data field whose values are used to calculate the summary. The Min and Max functions require a numeric or date-time data field. The Avg and Sum functions work with numeric fields only. For the Count function, you do not need to set this property.
  • ShowInColumn – Specifies the name of the column used to display the summary.
  • DisplayFormat – Specifies summary display format. The ‘{0}’ placeholder returns the summary value and ‘{1}’ returns the parent column’s caption. If you do not specify this property, the following format is applied: ‘{Summary function}: {summary value}’.

Group Summary

Region: Africa (Count: 15)
Region: Asia (Count: 20)
Region: Australia (Count: 10)
Region: Europe (Count: 17)
Region: North America (Count: 29)
Region: South America (Count: 16)

Group summaries (using aggregate functions such as Sum, Min, Max, Avg, and Count) are calculated across all rows within a group and displayed in the group row or group footer. To create group summaries, add DxDataGridSummaryItem objects to the GroupSummary collection.

Use the GroupSummaryPosition property to position group summaries. The following values are available: