|
|
|
|
|
||
|---|---|---|---|---|---|
| Country: Argentina (Count: 34, Sum of Total: $8,158.00) | |||||
| Country: Austria (Count: 125, Sum of Total: $139,924.00) | |||||
| Country: Belgium (Count: 56, Sum of Total: $35,122.00) | |||||
| Country: Brazil (Count: 203, Sum of Total: $115,121.00) | |||||
| Country: Canada (Count: 75, Sum of Total: $55,358.00) | |||||
| Country: Denmark (Count: 46, Sum of Total: $34,800.00) | |||||
| Country: Finland (Count: 54, Sum of Total: $19,780.00) | |||||
| Country: France (Count: 184, Sum of Total: $85,624.00) | |||||
| Country: Germany (Count: 328, Sum of Total: $244,614.00) | |||||
| Country: Ireland (Count: 55, Sum of Total: $57,393.00) | |||||
| Country: Italy (Count: 53, Sum of Total: $16,782.00) | |||||
| Country: Mexico (Count: 72, Sum of Total: $24,136.00) | |||||
| Country: Norway (Count: 16, Sum of Total: $5,745.00) | |||||
| Country: Poland (Count: 16, Sum of Total: $3,565.00) | |||||
| Country: Portugal (Count: 30, Sum of Total: $12,420.00) | |||||
| Country: Spain (Count: 54, Sum of Total: $19,485.00) | |||||
| Country: Sweden (Count: 97, Sum of Total: $59,673.00) | |||||
| Country: Switzerland (Count: 52, Sum of Total: $32,975.00) | |||||
| Country: UK (Count: 135, Sum of Total: $60,784.00) | |||||
| Country: USA (Count: 352, Sum of Total: $264,008.00) | |||||
Data grid with 21 rows and 4 columns
Group summaries are calculated across all rows within a group and displayed in the group row or group footer. To create group summaries, declare DxGridSummaryItem objects in the GroupSummary template.
You can use the following DxGridSummaryItem properties:
- SummaryType — Specifies the function type (Sum, Min, Max, Avg, or Count).
- FieldName — Specifies the name of the data field whose values are used to calculate the summary. The Min and Max functions support data fields whose values can be compared. The Avg and Sum functions work with numeric fields only. For the Count function, you do not need to set this property.
- DisplayText — Specifies display text pattern for the summary item. A display text string can include static text and placeholders for summary value and column caption.
- ValueDisplayFormat — Specifies the pattern used to format the summary value. If you do not define this property, the summary applies the format from the column bound to the same data field (FieldName. For more information about supported formats, see the following help topic: Format types in .NET.
- FooterColumnName — Specifies the name of the group footer column that displays the summary value. If you do not define this property, the summary value is displayed in the group row.
- Visible — Allows you to show/hide individual summary items.
In this demo, group rows display the number of rows and total prices within groups.