Enum SummaryType
Enumerates the summary types available for calculations in the Pivot control. If you use the value "Custom" in a ComputationInfo object, then you are required to explicitly set the ComputationInfo.Summary value.
Namespace: Syncfusion.XlsIO.Implementation.PivotAnalysis
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public enum SummaryTypeFields
| Name | Description |
|---|---|
| Average | Computes the average of values. |
| Count | Computes the count of double or integer values. |
| CountNumbers | Computes the count of integer values. |
| Custom | Specifies that you are using a custom SummaryBase object to define the calculation. |
| DecimalTotalSum | Computes the sum of decimal values. |
| DisplayIfDiscreteValuesEqual | Displays the common value if all the values to be aggregated are the same, and displays a DisplayIfDiscreteValuesEqual if the values to be aggregated are not all the same. |
| DoubleAverage | Computes the simple average of double or integer values. |
| DoubleMaximum | Computes the maximum of double or integer values. |
| DoubleMinimum | Computes the minimum of double or integer values. |
| DoubleStandardDeviation | Computes the standard deviation of double or integer values. |
| DoubleTotalSum | Computes the sum of double or integer values. |
| DoubleVariance | Computes the variance of double or integer values. |
| IntTotalSum | Computes the sum of integer values. |
| Max | Computes the maximum of values. |
| Min | Computes the minimum of values. |
| StdDev | Computes the standard deviation of values if data set contains a sample of the population. |
| StdDevP | Computes the standard deviation of values if data set contains a complete population. |
| Sum | Computes the sum of values. |
| Var | Computes the variance of values if data set contains a sample of the population. |
| VarP | Computes the variance of values if data set contains a complete population. |