Google Sheets · Schema

PivotFilterCriteria

Criteria for showing/hiding rows in a pivot table.

Google WorkspaceProductivitySpreadsheets

Properties

Name Type Description
visibleValues array Values that should be included.
visibleByDefault boolean Whether values are visible by default.
View JSON Schema on GitHub

JSON Schema

google-sheets-pivot-filter-criteria-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "PivotFilterCriteria",
  "type": "object",
  "description": "Criteria for showing/hiding rows in a pivot table.",
  "properties": {
    "visibleValues": {
      "type": "array",
      "description": "Values that should be included."
    },
    "visibleByDefault": {
      "type": "boolean",
      "description": "Whether values are visible by default."
    }
  }
}