Enum PivotTableSummarizeFunction
Stay organized with collections
Save and categorize content based on your preferences.
Spark icon
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.
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 |