TcxPivotGridSummaryType Enum

Enumerates calculation options.

Declaration

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.