'Declaration
Public Enum AggregateEnum Inherits System.Enum
public enum AggregateEnum : System.Enum
'Declaration
Public Enum AggregateEnum Inherits System.Enum
public enum AggregateEnum : System.Enum
Member | 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 C1FlexGridBase.Aggregate 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). |
System.Object
System.ValueType
System.Enum
C1.Win.C1FlexGrid.AggregateEnum