AI-generated Key Takeaways
-
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 | 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 |