Tag

PivotGridField.SortByCustomTotalSummaryType Property

Gets or sets the summary type of custom total values by which the current field values are sorted. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v21.1.dll

Declaration

public FieldSummaryType? SortByCustomTotalSummaryType { get; set; }

Property Value

Type Description
Nullable<FieldSummaryType>

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

Available values:

Show 13 items
Name Description
Count

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

Sum

The sum of the values.

Min

The smallest value.

Max

The largest value.

Average

The average of the values.

StdDev

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

StdDevp

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

Var

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

Varp

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

Custom

The calculations should be performed manually using the PivotGridControl.CustomSummary event.

CountDistinct
Median
Mode

Remarks

The SortByCustomTotalSummaryType 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 SortByCustomTotalSummaryType property is set to null.

See Also