CS Knowledge Base

Enum PivotTableSummarizeFunction

  • 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 CUSTOM property 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

PropertyTypeDescription
CUSTOMEnumA custom function, this value is only valid for calculated fields.
SUMEnumThe SUM function
COUNTAEnumThe COUNTA function
COUNTEnumThe COUNT function
COUNTUNIQUEEnumThe COUNTUNIQUE function
AVERAGEEnumThe AVERAGE function
MAXEnumThe MAX function
MINEnumThe MIN function
MEDIANEnumThe MEDIAN function
PRODUCTEnumThe PRODUCT function
STDEVEnumThe STDEV function
STDEVPEnumThe STDEVP function
VAREnumThe VAR function
VARPEnumThe VARP function