Skip to main content
A newer version of this page is available. .

PivotGridFieldSortBySummaryInfo.CustomTotalSummaryType Property

Gets or sets the summary type of the custom total column/row, by which the current field values are sorted.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v19.2.Core.dll

Declaration

[DefaultValue(null)]
public PivotSummaryType? CustomTotalSummaryType { get; set; }

Property Value

Type Default Description
Nullable<PivotSummaryType> *null*

A PivotSummaryType object representing the summary type of the custom total column/row, by which the field values are sorted. Null if the field values are not sorted by a custom total column/row.

Available values:

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.

Remarks

The CustomTotalSummaryType property is in effect when the field values are sorted by a custom total column/row. In this instance, this property specifies the summary type of the custom total. Otherwise, the CustomTotalSummaryType property is set to null.

To apply sorting by summary to the field, use the PivotGridFieldBase.SetSortBySummary method.

See Also