Google Sheets · JSON Structure

Google Sheets Pivot Value Structure

Type: object Properties: 5

Google WorkspaceProductivitySpreadsheets

PivotValue is a JSON Structure definition published by Google Sheets, describing 5 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

summarizeFunction name calculatedDisplayType sourceColumnOffset formula

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "PivotValue",
  "type": "object",
  "properties": {
    "summarizeFunction": {
      "type": "string"
    },
    "name": {
      "type": "string"
    },
    "calculatedDisplayType": {
      "type": "string"
    },
    "sourceColumnOffset": {
      "type": "integer"
    },
    "formula": {
      "type": "string"
    }
  }
}