Enum PivotTableSummarizeFunction

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

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