TcxPivotGridSummaryType Enum

Enumerates calculation options.

Declaration

delphi

TcxPivotGridSummaryType = (
    stCount,
    stSum,
    stMin,
    stMax,
    stAverage,
    stStdDev,
    stStdDevP,
    stVariance,
    stVarianceP,
    stCustom,
    stCountDistinct
);

Members

Name
`stCount`
`stSum`
`stMin`
`stMax`
`stAverage`
`stStdDev`
`stStdDevP`
`stVariance`
`stVarianceP`
`stCustom`
`stCountDistinct`

Remarks

Options include:

Value

Function Name

Meaning

| | --- | --- | --- | |

stCount

Count

Counts values

| |

stCountDistinct

Count of Distinct Values

Counts distinct values. This function is not supported in OLAP mode.

| |

stSum

Sum

Returns a total of numeric values

| |

stMin

Min

Returns the lowest value

| |

stMax

Max

Returns the highest value

| |

stAverage

Average

Returns an average of numeric values

| |

stStdDev

Sample Standard Deviation

Returns the sample standard deviation of numeric values

| |

stStdDevP

Population Standard Deviation

Returns the population standard deviation of numeric values

| |

stVariance

Sample Variance

Returns the sample variance of numeric values

| |

stVarianceP

Population Variance

Returns the population variance of numeric values

| |

stCustom

Custom

Performs custom calculations. Handle a field’s OnCalculateCustomSummary event to provide custom summaries. Refer to the example on how to do this.

You can calculate any summary function with numeric and date-time field values. For date-time field values, the function result’s data type depends on the function used:

The Min and Max summary functions return a date-time value.
The Count and Count of Distinct Values summary functions return an integer value.
All other summary functions convert the field values to floating-point values and return a floating-point value as the result.

With string field values, you can use the Count, Count of Distinct Values, Min, and Max summary functions. With non-numeric field values, you can use only the Count and Count of Distinct Values summary functions. The corresponding data cells display blanks if you use any unsupported summary function.