How to: Add Custom Totals

• Jun 27, 2019

In the following example, four custom totals are added for a ‘Category Name’ row field. They will calculate the total Average, Sum, Min and Max values against the currently displayed data field.

The result is shown below.

C#

using DevExpress.Data.PivotGrid;
using DevExpress.XtraPivotGrid;

// Get a reference to the CategoryName field.
PivotGridField field = pivotGridControl1.Fields["CategoryName"];
pivotGridControl1.BeginUpdate();
try {
   // Clear the custom total collection.
   field.CustomTotals.Clear();
   // Add four items to the custom total collection to calculate the Average, 
   // Sum, Max and Min summaries.
   field.CustomTotals.Add(PivotSummaryType.Average);
   field.CustomTotals.Add(PivotSummaryType.Sum);
   field.CustomTotals.Add(PivotSummaryType.Max);
   field.CustomTotals.Add(PivotSummaryType.Min);
   // Make the custom totals visible for this field.
   field.TotalsVisibility = PivotTotalsVisibility.CustomTotals; 
}
finally {
   pivotGridControl1.EndUpdate();
}

VB.NET

Imports DevExpress.Data.PivotGrid
Imports DevExpress.XtraPivotGrid

' Get a reference to the CategoryName field.
Dim field As PivotGridField = pivotGridControl1.Fields("CategoryName")
pivotGridControl1.BeginUpdate()
Try
   ' Clear the custom total collection.
   field.CustomTotals.Clear()
   ' Add four items to the custom total collection to calculate the Average, 
   ' Sum, Max and Min summaries.
   field.CustomTotals.Add(PivotSummaryType.Average)
   field.CustomTotals.Add(PivotSummaryType.Sum)
   field.CustomTotals.Add(PivotSummaryType.Max)
   field.CustomTotals.Add(PivotSummaryType.Min)
   ' Make the custom totals visible for this field.
   field.TotalsVisibility = PivotTotalsVisibility.CustomTotals
Finally
   pivotGridControl1.EndUpdate()
End Try