Skip to main content
All docs
V25.1
  • MovingCalculationBindingBase.SummaryType Property

    Gets or sets the aggregation type.

    Namespace: DevExpress.PivotGrid.DataBinding

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

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

    Declaration

    [DefaultValue(PivotSummaryType.Average)]
    public PivotSummaryType SummaryType { get; set; }

    Property Value

    Type Default Description
    PivotSummaryType Average

    A PivotSummaryType enumeration member that specifies the aggregation type.

    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.

    See Also