PivotSummaryValue.Average Property

Returns the value of the PivotSummaryType.Average function for the current cell.

Namespace: DevExpress.Data.PivotGrid

Assembly: DevExpress.PivotGrid.v24.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

public object Average { get; }

VB.NET

Public ReadOnly Property Average As Object

Property Value

Type	Description
Object	The value of the PivotSummaryType.Average function for the current cell. If an error occured during calculation, the PivotSummaryValue.ErrorValue property’s value is returned.

Related GitHub Examples

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

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#

winforms-pivot-grid-provide-custom-summary-values-for-cells/CS/WinPivotCustomSummaryCellType/Form1.cs#L28

if (e.RowField.AreaIndex == lastRowFieldIndex && e.ColumnField.AreaIndex == lastColumnFieldIndex) {
    e.CustomValue = e.SummaryValue.Average;
}

VB.NET

winforms-pivot-grid-provide-custom-summary-values-for-cells/VB/VBWinPivotCustomSummaryCellType/Form1.vb#L28

If e.RowField.AreaIndex = lastRowFieldIndex AndAlso e.ColumnField.AreaIndex = lastColumnFieldIndex Then
    e.CustomValue = e.SummaryValue.Average
    ' This is a Total cell.