ComponentOne FlexPivot for WinForms
C1.Win.FlexPivot.4.8 Assembly / C1.Win.FlexPivot Namespace / C1FlexPivotGrid Class / Subtotal Method / Subtotal(AggregateEnum,Int32,String,String,String) Method
C1.Win.C1FlexGrid.AggregateEnum value that specifies the type of aggregate to calculate.
Outline level to assign to the new subtotal rows. This parameter allows the creation of multi-level subtotals and affects the display of the outline tree.
Name column used to detect group breaks.
Name of the column that contains values to be aggregated (usually numeric).
Text to insert in the subtotal rows.

In This Topic
    Subtotal(AggregateEnum,Int32,String,String,String) Method
    In This Topic
    Groups rows based on cell contents and calculates aggregate values.
    Syntax
    'Declaration
     
    Public Overloads Sub Subtotal( _
       ByVal aggType As AggregateEnum, _
       ByVal level As Integer, _
       ByVal groupOn As String, _
       ByVal totalOn As String, _
       ByVal caption As String _
    ) 
    public void Subtotal( 
       AggregateEnum aggType,
       int level,
       string groupOn,
       string totalOn,
       string caption
    )

    Parameters

    aggType
    C1.Win.C1FlexGrid.AggregateEnum value that specifies the type of aggregate to calculate.
    level
    Outline level to assign to the new subtotal rows. This parameter allows the creation of multi-level subtotals and affects the display of the outline tree.
    groupOn
    Name column used to detect group breaks.
    totalOn
    Name of the column that contains values to be aggregated (usually numeric).
    caption
    Text to insert in the subtotal rows.
    Remarks
    This is a variant of the C1.Win.C1FlexGrid.C1FlexGridBase.Subtotal method that takes column names instead of indices.
    See Also