Google Sheets · Schema

PivotValue

The definition of how a value in a pivot table should be calculated.

Google WorkspaceProductivitySpreadsheets

Properties

Name Type Description
summarizeFunction string A function to summarize the value.
name string A name to use for the value.
calculatedDisplayType string If specified, indicates that pivot values should be displayed as the result of a calculation with another pivot value.
sourceColumnOffset integer The column offset of the source range that this value reads from.
formula string A custom formula to calculate the value.
View JSON Schema on GitHub