Google Sheets · Schema

PivotGroup

A single grouping (either row or column) in a pivot table.

Google WorkspaceProductivitySpreadsheets

Properties

Name Type Description
sourceColumnOffset integer The column offset of the source range that this grouping is based on.
showTotals boolean True if the pivot table should include the totals for this grouping.
sortOrder string The order the values in this group should be sorted.
repeatHeadings boolean True if the headings in this pivot group should be repeated.
label string The labels to use for the row/column groups which can be customized.
View JSON Schema on GitHub