Enum PivotTableSummarizeFunction

AI-generated Key Takeaways

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.

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.

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