TcxPivotGridSummaryType Enum
Enumerates calculation options.
#Declaration
TcxPivotGridSummaryType = (
stCount,
stSum,
stMin,
stMax,
stAverage,
stStdDev,
stStdDevP,
stVariance,
stVarianceP,
stCustom,
stCountDistinct
);
#Members
Name |
---|
st
|
st
|
st
|
st
|
st
|
st
|
st
|
st
|
st
|
st
|
st
|
#Remarks
Options include:
Value | Function Name | Meaning |
---|---|---|
st | Count | Counts values |
st | Count of Distinct Values | Counts distinct values. This function is not supported in OLAP mode. |
st | Sum | Returns a total of numeric values |
st | Min | Returns the lowest value |
st | Max | Returns the highest value |
st | Average | Returns an average of numeric values |
st | Sample Standard Deviation | Returns the sample standard deviation of numeric values |
st | Population Standard Deviation | Returns the population standard deviation of numeric values |
st | Sample Variance | Returns the sample variance of numeric values |
st | Population Variance | Returns the population variance of numeric values |
st | Custom | Performs custom calculations. Handle a field’s On |
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.