PivotGridCustomTotal Class

Represents a custom total which can be calculated for an outer column field or row field.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v17.2.dll

Declaration

C#

public class PivotGridCustomTotal :
    PivotGridCustomTotalBase

VB.NET

Public Class PivotGridCustomTotal
    Inherits PivotGridCustomTotalBase

Related API Members

The following members accept/return PivotGridCustomTotal objects:

• PivotFieldStateChangedEventArgs.CustomTotal
• PivotFieldValueEventArgs.CustomTotal
• PivotGridCustomTotalCollection.Item[Int32]
• WebCustomExportFieldValueEventArgs.CustomTotal

Remarks

The ASPxPivotGrid control supports automatic and custom Totals. An automatic total is calculated against a data field using a summary function determined by the field’s PivotGridFieldBase.SummaryType property.

A custom total allows you to calculate a total using a different summary function type. In addition, it’s possible to calculate multiple custom totals for one data field.

Totals are displayed as additional rows or columns for each value in an outer column field or row field. To display custom totals for a column/row field, do the following:

• add PivotGridCustomTotal objects which represent custom totals to the field’s PivotGridField.CustomTotals collection;
• set the field’s PivotGridFieldBase.TotalsVisibility property to PivotTotalsVisibility.CustomTotals.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the PivotGridCustomTotal class.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-calculate-multiple-custom-totals-with-summarytype-set-to-custom-e3821/CS/ASPxPivotGrid_MultipleCustomTotals/Default.aspx.cs#L12

// Creates a PivotGridCustomTotal object that defines the Median Custom Total.
PivotGridCustomTotal medianCustomTotal = new PivotGridCustomTotal(PivotSummaryType.Custom);

VB.NET

how-to-calculate-multiple-custom-totals-with-summarytype-set-to-custom-e3821/VB/ASPxPivotGrid_MultipleCustomTotals/Default.aspx.vb#L16

' Creates a PivotGridCustomTotal object that defines the Median Custom Total.
Dim medianCustomTotal As New PivotGridCustomTotal(PivotSummaryType.Custom)

Inheritance

Object

PivotGridCustomTotalBase

PivotGridCustomTotal