Subtotal(AggregateEnum,Int32,String,String,String,String) Method

In This Topic

Groups rows based on cell contents and calculates aggregate values.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub Subtotal( _
   ByVal aggType As AggregateEnum, _
   ByVal level As Integer, _
   ByVal groupFrom As String, _
   ByVal groupTo As String, _
   ByVal totalOn As String, _
   ByVal caption As String _
)

public void Subtotal( 
   AggregateEnum aggType,
   int level,
   string groupFrom,
   string groupTo,
   string totalOn,
   string caption
)

Parameters

aggType: 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.
groupFrom: Name of the first column in the range used to detect group breaks.
groupTo: Name of the last column in the range 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 C1FlexGridBase.Subtotal method that takes column names instead of indices.

Reference

C1FlexGrid Class
C1FlexGrid Members
Overload List