API REFERENCE
pivotSubtotals
Hides nested pivot subtotals or positions them above or below expanded groups.
What does this API do?
Hides nested pivot subtotals or positions them above or below expanded groups.
API for Pro features: Pivot
Exact input and result types
pivotSubtotals: 'off' | 'top' | 'bottom'| Item | Value |
|---|---|
| JavaScript name | pivotSubtotals |
| HTML attribute | pivot-subtotals |
| Default | 'off' |
| Input type | 'off' | 'top' | 'bottom' |
Usage flow
Set this on a property of the Grid element. In HTML, you can also use the pivot-subtotals attribute. Pass arrays, objects, and callbacks through JavaScript, and use new arrays or objects when applying changes.
Feature explanations and examples
- Pivot analysis
Pivoting divides source orders into row, column, and value axes to create a cross-tabulation. Unlike collapsible row groups, unique values such as statuses become new result columns.