## SubtotalSetting class

Represents the setting of the subtotal .

## Properties

| Name | Type | Description |
| --- | --- | --- |
| [GroupBy](#groupby) | Number | The field to group by, as a zero-based integer offset |
| [SubtotalFunction](#subtotalfunction) | Number | The subtotal function. The value of the property is ConsolidationFunction integer constant. |
| [TotalList](#totallist) | int[] | An array of zero-based field offsets, indicating the fields to which the subtotals are added. |
| [SummaryBelowData](#summarybelowdata) | boolean | Indicates whether add summary below data. |

### SubtotalSetting.GroupBy property {#groupby}

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

**Type:** Number

### SubtotalSetting.SubtotalFunction property {#subtotalfunction}

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

**Type:** Number

### SubtotalSetting.TotalList property {#totallist}

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

**Type:** int[]

### SubtotalSetting.SummaryBelowData property {#summarybelowdata}

Indicates whether add summary below data.

**Type:** boolean