SubtotalSetting

SubtotalSetting class

Represents the setting of the subtotal .

Methods

NameDescription
getGroupBy()The field to group by, as a zero-based integer offset
getSubtotalFunction()The subtotal function. The value of the property is ConsolidationFunction integer constant.
getSummaryBelowData()Indicates whether add summary below data.
getTotalList()An array of zero-based field offsets, indicating the fields to which the subtotals are added.

getGroupBy()

The field to group by, as a zero-based integer offset

getSubtotalFunction()

The subtotal function. The value of the property is ConsolidationFunction integer constant.

getSummaryBelowData()

Indicates whether add summary below data.

getTotalList()

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