calculatedDisplayType property

String? calculatedDisplayType
getter/setter pair

If specified, indicates that pivot values should be displayed as the result of a calculation with another pivot value.

For example, if calculated_display_type is specified as PERCENT_OF_GRAND_TOTAL, all the pivot values are displayed as the percentage of the grand total. In the Sheets editor, this is referred to as "Show As" in the value section of a pivot table. Possible string values are:

  • "PIVOT_VALUE_CALCULATED_DISPLAY_TYPE_UNSPECIFIED" : Default value, do not use.
  • "PERCENT_OF_ROW_TOTAL" : Shows the pivot values as percentage of the row total values.
  • "PERCENT_OF_COLUMN_TOTAL" : Shows the pivot values as percentage of the column total values.
  • "PERCENT_OF_GRAND_TOTAL" : Shows the pivot values as percentage of the grand total values.

Implementation

core.String? calculatedDisplayType;