Enum PivotTableSummarizeFunction
PivotTableSummarizeFunction
An enumeration of functions that summarize pivot table data.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.PivotTableSummarizeFunction.CUSTOM
.
Properties
Property | Type | Description |
CUSTOM | Enum | A custom function, this value is only valid for calculated fields. |
SUM | Enum | The SUM function |
COUNTA | Enum | The COUNTA function |
COUNT | Enum | The COUNT function |
COUNTUNIQUE | Enum | The COUNTUNIQUE function |
AVERAGE | Enum | The AVERAGE function |
MAX | Enum | The MAX function |
MIN | Enum | The MIN function |
MEDIAN | Enum | The MEDIAN function |
PRODUCT | Enum | The PRODUCT function |
STDEV | Enum | The STDEV function |
STDEVP | Enum | The STDEVP function |
VAR | Enum | The VAR function |
VARP | Enum | The VARP function |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[null,null,["Last updated 2024-12-02 UTC."],[[["`PivotTableSummarizeFunction` is an enumeration of functions used to summarize data within Google Sheets pivot tables."],["It provides access to common aggregation functions like `SUM`, `AVERAGE`, `COUNT`, `MAX`, `MIN`, and more for summarizing pivot table data."],["To use a function, call it using the parent class, name, and property, such as `SpreadsheetApp.PivotTableSummarizeFunction.SUM`."],["Includes a `CUSTOM` property for using custom functions within calculated fields in pivot tables."]]],[]]