Back to Devexpress

How to: Add Multiple Total Summaries for Column

windowsforms-9678-controls-and-libraries-data-grid-examples-summaries-how-to-add-multiple-total-summaries-for-column.md

latest1.2 KB
Original Source

How to: Add Multiple Total Summaries for Column

  • Nov 13, 2018

This example demonstrates how to add multiple total summaries for a column at runtime.

csharp
using DevExpress.XtraGrid;
//...

gridView1.Columns["UnitsInStock"].Summary.Add(new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Average, "UnitsInStock", "Avg={0:n2}"));
gridView1.Columns["UnitsInStock"].Summary.Add(new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, "UnitsInStock", "Sum={0}"));
gridView1.Columns["UnitsInStock"].Summary.Add(new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Max, "UnitsInStock", "Max={0}"));
vb
Imports DevExpress.XtraGrid
'...

gridView1.Columns("UnitsInStock").Summary.Add(New GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Average, "UnitsInStock", "Avg={0:n2}"))
gridView1.Columns("UnitsInStock").Summary.Add(New GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, "UnitsInStock", "Sum={0}"))
gridView1.Columns("UnitsInStock").Summary.Add(New GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Max, "UnitsInStock", "Max={0}"))