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.
Pivot
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 |
