ComponentOne FlexPivot for WinForms
C1.Win.C1FlexGrid.4.5.2 Assembly / C1.Win.C1FlexGrid Namespace / AggregateEnum Enumeration

In This Topic
    AggregateEnum Enumeration
    In This Topic
    Specifies the type of aggregate function to calculate with the C1FlexGridBase.Aggregate 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.
    Syntax
    'Declaration
     
    Public Enum AggregateEnum 
       Inherits System.Enum
    public enum AggregateEnum : System.Enum 
    Members
    MemberDescription
    AverageReturns the average value of the non-empty cells in a range.
    ClearClear 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.
    CountReturns the count of non-empty cells in a range.
    CountDistinctReturns the count of unique non-empty cells in a range.
    MaxReturns the maximum value in a range.
    MinReturns the minimum value in a range.
    NoneNo 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.
    PercentPercent 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).
    StdReturns the sample standard deviation of the values in a range (uses the formula based on n-1).
    StdPopReturns the population standard deviation of the values in a range (uses the formula based on n).
    SumReturns the sum of all values in the range.
    VarReturns the sample variance of the values in a range (uses the formula based on n-1).
    VarPopReturns the population variance of the values in a range (uses the formula based on n).
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             C1.Win.C1FlexGrid.AggregateEnum

    See Also