You can display multiple total summaries within a column's footer. To add summaries for a column, use the GridColumn.Summary collection. This collection's elements are GridColumnSummaryItem objects.
The GridColumnSummaryItem objects have the following properties:
The image below shows total summaries in a column's footer.
Example
The example demonstrates how to add a total summary and set its summary type, field name and display format. Note that a summary is added for the Units In Stock column and it will be shown in this column. However, the summary will be calculated against a Unit Price field name.
| C# |
GridColumnSummaryItem item = colUnitsInStock1.Summary.Add();
item.SummaryType = DevExpress.Data.SummaryItemType.Average;
item.FieldName = "UnitPrice";
item.DisplayFormat = "Average Unit Price = {0:c2}";
|
| VB |
Dim item As GridColumnSummaryItem = colUnitsInStock1.Summary.Add()
item.SummaryType = DevExpress.Data.SummaryItemType.Average
item.FieldName = "UnitPrice"
item.DisplayFormat = "Average Unit Price = {0:c2}"
|
System.Object
GridSummaryItem
GridColumnSummaryItem