Enum PivotTableSummarizeFunction
Page Summary
PivotTableSummarizeFunction is an enumeration of functions that summarize pivot table data.
To call an enum, you use its parent class, name, and property, like
SpreadsheetApp.PivotTableSummarizeFunction.CUSTOM.The enumeration includes properties for various common summary functions such as SUM, AVERAGE, COUNT, and MAX.
There is also a
CUSTOMproperty valid for calculated fields.
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 | TheSUM function |
COUNTA | Enum | TheCOUNTA function |
COUNT | Enum | TheCOUNT function |
COUNTUNIQUE | Enum | TheCOUNTUNIQUE function |
AVERAGE | Enum | TheAVERAGE function |
MAX | Enum | TheMAX function |
MIN | Enum | TheMIN function |
MEDIAN | Enum | TheMEDIAN function |
PRODUCT | Enum | ThePRODUCT function |
STDEV | Enum | TheSTDEV function |
STDEVP | Enum | TheSTDEVP function |
VAR | Enum | TheVAR function |
VARP | Enum | TheVARP function |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-11 UTC.