Enum PivotValueDisplayType
PivotValueDisplayType
An enumeration of ways to display a pivot value as a function of another value.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.PivotValueDisplayType.PERCENT_OF_ROW_TOTAL.
Properties
| Property | Type | Description |
DEFAULT | Enum | Default. Displays pivot values as the actual value and not as a function of another value. |
PERCENT_OF_ROW_TOTAL | Enum | Displays pivot values as a percent of the total for that row. |
PERCENT_OF_COLUMN_TOTAL | Enum | Displays pivot values as a percent of the total for that column. |
PERCENT_OF_GRAND_TOTAL | Enum | Displays pivot values as a percent of the grand total. |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-10-31 UTC.
[null,null,["Last updated 2024-10-31 UTC."],[[["`PivotValueDisplayType` is used to control how values are displayed in a pivot table, offering options to present them as raw values or percentages relative to row, column, or grand totals."],["To utilize a specific display type, reference it using the format `SpreadsheetApp.PivotValueDisplayType.[property]`, such as `SpreadsheetApp.PivotValueDisplayType.PERCENT_OF_ROW_TOTAL` for displaying values as a percentage of the row total."],["Available display types include `DEFAULT` (displays the raw value), `PERCENT_OF_ROW_TOTAL`, `PERCENT_OF_COLUMN_TOTAL`, and `PERCENT_OF_GRAND_TOTAL`."]]],[]]
