[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

GrapeCity.Documents.Excel.IRange.Subtotal

Subtotal Method

Subtotal(int, ConsolidationFunction, IEnumerable<int>, bool, bool, SummaryRow)

Creates subtotals for the range.

Declaration
void Subtotal(int groupBy, ConsolidationFunction subtotalFunction, IEnumerable<int> totalList, bool replace = true, bool pageBreaks = false, SummaryRow summaryRowLocation = SummaryRow.Below)
Sub Subtotal(groupBy As Integer, subtotalFunction As ConsolidationFunction, totalList As IEnumerable(Of Integer), Optional replace As Boolean = True, Optional pageBreaks As Boolean = False, Optional summaryRowLocation As SummaryRow = SummaryRow.Below)
Parameters
Type Name Description
int groupBy

The field to group by, as a one-based integer offset.
ConsolidationFunction subtotalFunction

The subtotal function.
IEnumerable<int> totalList

An array of 1-based field offsets, indicating the fields to which the subtotals are added.
bool replace

True to replace existing subtotals. The default value is True.
bool pageBreaks

True to add page breaks after each group. The default value is False.
SummaryRow summaryRowLocation

Places the summary data relative to the subtotal.