Total Summary Computation

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.

  • Field – Specifies the name of the data field whose values are used to calculate the summary.
  • SummaryType – Specifies the aggregate function (SUM, MIN, MAX, AVG, etc) used.
  • 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.
11/12/2020 Argentina Alice Mutton $9.00
11/15/2020 Germany Aniseed Syrup $4.00
11/24/2020 Bhutan Boston Crab Meat $3.00
11/22/2020 Cyprus Camembert Pierrot $11.00
11/23/2020 Iraq Carnarvon Tigers $6.00
11/20/2020 Gibraltar Chai $1.00
11/11/2020 Kiribati Chang $6.00
11/21/2020 Lao People's Democratic Republic Chartreuse verte $1.00
11/13/2020 Canada Chef Anton's Cajun Seasoning $1.00
11/21/2020 Micronesia, Federated States of Chef Anton's Gumbo Mix $2.00
First: Tuesday, November 10, 2020
Count: 75
Sum: $398.00

Group Summary Computations

Group summaries (using aggregate functions such as SUM, MIN, MAX, AVG, etc) 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:

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)