summarizeFunction property

String? summarizeFunction
getter/setter pair

A function to summarize the value.

If formula is set, the only supported values are SUM and CUSTOM. If sourceColumnOffset is set, then CUSTOM is not supported. Possible string values are:

  • "PIVOT_STANDARD_VALUE_FUNCTION_UNSPECIFIED" : The default, do not use.
  • "SUM" : Corresponds to the SUM function.
  • "COUNTA" : Corresponds to the COUNTA function.
  • "COUNT" : Corresponds to the COUNT function.
  • "COUNTUNIQUE" : Corresponds to the COUNTUNIQUE function.
  • "AVERAGE" : Corresponds to the AVERAGE function.
  • "MAX" : Corresponds to the MAX function.
  • "MIN" : Corresponds to the MIN function.
  • "MEDIAN" : Corresponds to the MEDIAN function.
  • "PRODUCT" : Corresponds to the PRODUCT function.
  • "STDEV" : Corresponds to the STDEV function.
  • "STDEVP" : Corresponds to the STDEVP function.
  • "VAR" : Corresponds to the VAR function.
  • "VARP" : Corresponds to the VARP function.
  • "CUSTOM" : Indicates the formula should be used as-is. Only valid if PivotValue.formula was set.

Implementation

core.String? summarizeFunction;