Skip to main content

PivotCustomDrawCellBaseEventArgs.SummaryType Property

Gets the type of summary calculated in the current cell.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v23.2.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

public PivotSummaryType SummaryType { get; }

Property Value

Type Description
PivotSummaryType

A PivotSummaryType enumeration value that specifies the summary type for the current cell.

Available values:

Show 13 items
Name Description
Count

The number of values (excluding Null and DBNull values).

Sum

The sum of the values.

func_sum

Min

The smallest value.

Max

The largest value.

Average

The average of the values.

func_average

StdDev

An estimate of the standard deviation of a population, where the sample is a subset of the entire population.

func_stddev

StdDevp

The standard deviation of a population, where the population is all of the data to be summarized.

func_stddevp

Var

An estimate of the variance of a population, where the sample is a subset of the entire population.

func_var

Varp

The variance of a population, where the population is all of the data to be summarized.

func_varp

Custom

Specifies whether calculations should be performed manually, by handling the CustomSummary event.

Not supported in OLAP and server mode.

CountDistinct

The number of distinct values. This function works only in the Optimized mode.

Median

The median of the values. A median is the number separating the higher half of a value range from the lower half. This function works only in the Optimized mode.

Mode

The mode of the values. A mode is the value that is repeated more often than any other. This function works only in the Optimized mode.

Remarks

Note

If you try to access the SummaryType property while an asynchronous operation is being performed, an exception will be thrown. When the operation is in progress, use the PivotCustomDrawCellBaseThreadSafeEventArgs.SummaryType property exposed by a thread-safe event parameter instead. To access the thread-safe event parameter, use the PivotCustomDrawCellBaseEventArgs.ThreadSafeArgs property. To determine whether an asynchronous operation is being performed, use the pivot grid’s IThreadSafeAccessible.IsAsyncInProgress property. For more information, see Asynchronous Mode.

See Also