[]
Specifies the type of aggregate function to calculate with the Aggregate(AggregateEnum, CellRange, AggregateFlags) and C1.Win.C1FlexGrid.C1FlexGridBase.Subtotal(C1.Win.C1FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.C1FlexGrid.AggregateFlags,C1.Win.C1FlexGrid.RowColFlags) methods.
public enum AggregateEnum
Name | Description |
---|---|
Average | Returns the average value of the non-empty cells in a range. |
Clear | Clear existing aggregates. This setting is used with the C1.Win.C1FlexGrid.C1FlexGridBase.Subtotal(C1.Win.C1FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.C1FlexGrid.AggregateFlags,C1.Win.C1FlexGrid.RowColFlags) method to clear any existing subtotals, usually before calculating new subtotals. |
Count | Returns the count of non-empty cells in a range. |
CountDistinct | Returns the count of unique non-empty cells in a range. |
Max | Returns the maximum value in a range. |
Min | Returns the minimum value in a range. |
None | No aggregate. This setting is used with the C1.Win.C1FlexGrid.C1FlexGridBase.Subtotal(C1.Win.C1FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.C1FlexGrid.AggregateFlags,C1.Win.C1FlexGrid.RowColFlags) method to create an outline tree without any numerical aggregates. |
Percent | Percent of grand total. This setting is used with the C1.Win.C1FlexGrid.C1FlexGridBase.Subtotal(C1.Win.C1FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.C1FlexGrid.AggregateFlags,C1.Win.C1FlexGrid.RowColFlags) method to calculate the percentage of the grand total represented by each sub group. (This setting can't be used with the Aggregate(AggregateEnum, CellRange, AggregateFlags) method). |
Std | Returns the sample standard deviation of the values in a range (uses the formula based on n-1). |
StdPop | Returns the population standard deviation of the values in a range (uses the formula based on n). |
Sum | Returns the sum of all values in the range. |
Var | Returns the sample variance of the values in a range (uses the formula based on n-1). |
VarPop | Returns the population variance of the values in a range (uses the formula based on n). |