Mit Sammlungen den Überblick behalten Sie können Inhalte basierend auf Ihren Einstellungen speichern und kategorisieren.
Pivot-TabelleSummeFunktion
Eine Aufzählung von Funktionen, mit denen Pivot-Tabellendaten zusammengefasst werden.
Wenn Sie ein Enum aufrufen möchten, rufen Sie die übergeordnete Klasse, den Namen und die Eigenschaft auf. Beispiel: SpreadsheetApp.PivotTableSummarizeFunction.CUSTOM.
Attribute
Attribut
Typ
Beschreibung
CUSTOM
Enum
Eine benutzerdefinierte Funktion, die nur für berechnete Felder gültig ist.
[[["Leicht verständlich","easyToUnderstand","thumb-up"],["Mein Problem wurde gelöst","solvedMyProblem","thumb-up"],["Sonstiges","otherUp","thumb-up"]],[["Benötigte Informationen nicht gefunden","missingTheInformationINeed","thumb-down"],["Zu umständlich/zu viele Schritte","tooComplicatedTooManySteps","thumb-down"],["Nicht mehr aktuell","outOfDate","thumb-down"],["Problem mit der Übersetzung","translationIssue","thumb-down"],["Problem mit Beispielen/Code","samplesCodeIssue","thumb-down"],["Sonstiges","otherDown","thumb-down"]],["Zuletzt aktualisiert: 2025-07-26 (UTC)."],[[["\u003cp\u003e\u003ccode\u003ePivotTableSummarizeFunction\u003c/code\u003e is an enumeration of functions used to summarize data within Google Sheets pivot tables.\u003c/p\u003e\n"],["\u003cp\u003eIt provides access to common aggregation functions like \u003ccode\u003eSUM\u003c/code\u003e, \u003ccode\u003eAVERAGE\u003c/code\u003e, \u003ccode\u003eCOUNT\u003c/code\u003e, \u003ccode\u003eMAX\u003c/code\u003e, \u003ccode\u003eMIN\u003c/code\u003e, and more for summarizing pivot table data.\u003c/p\u003e\n"],["\u003cp\u003eTo use a function, call it using the parent class, name, and property, such as \u003ccode\u003eSpreadsheetApp.PivotTableSummarizeFunction.SUM\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eIncludes a \u003ccode\u003eCUSTOM\u003c/code\u003e property for using custom functions within calculated fields in pivot tables.\u003c/p\u003e\n"]]],["`PivotTableSummarizeFunction` enumerates functions for summarizing pivot table data. These functions, accessed via `SpreadsheetApp.PivotTableSummarizeFunction`, include: `CUSTOM` (for calculated fields), `SUM`, `COUNTA`, `COUNT`, `COUNTUNIQUE`, `AVERAGE`, `MAX`, `MIN`, `MEDIAN`, `PRODUCT`, `STDEV`, `STDEVP`, `VAR`, and `VARP`. Each function corresponds to a specific Google Sheets formula, allowing for diverse data aggregation within pivot tables. Each property's type is `Enum`.\n"],null,["PivotTableSummarizeFunction\n\nAn enumeration of functions that summarize pivot table data.\n\nTo call an enum, you call its parent class, name, and property. For example, `\nSpreadsheetApp.PivotTableSummarizeFunction.CUSTOM`. \n\nProperties\n\n| Property | Type | Description |\n|---------------|--------|----------------------------------------------------------------------------|\n| `CUSTOM` | `Enum` | A custom function, this value is only valid for calculated fields. |\n| `SUM` | `Enum` | The [SUM](https://support.google.com/docs/answer/3093669) function |\n| `COUNTA` | `Enum` | The [COUNTA](https://support.google.com/docs/answer/3093991) function |\n| `COUNT` | `Enum` | The [COUNT](https://support.google.com/docs/answer/3093620) function |\n| `COUNTUNIQUE` | `Enum` | The [COUNTUNIQUE](https://support.google.com/docs/answer/3093405) function |\n| `AVERAGE` | `Enum` | The [AVERAGE](https://support.google.com/docs/answer/3093615) function |\n| `MAX` | `Enum` | The [MAX](https://support.google.com/docs/answer/3094013) function |\n| `MIN` | `Enum` | The [MIN](https://support.google.com/docs/answer/3094017) function |\n| `MEDIAN` | `Enum` | The [MEDIAN](https://support.google.com/docs/answer/3094025) function |\n| `PRODUCT` | `Enum` | The [PRODUCT](https://support.google.com/docs/answer/3093502) function |\n| `STDEV` | `Enum` | The [STDEV](https://support.google.com/docs/answer/3094054) function |\n| `STDEVP` | `Enum` | The [STDEVP](https://support.google.com/docs/answer/3094105) function |\n| `VAR` | `Enum` | The [VAR](https://support.google.com/docs/answer/3094063) function |\n| `VARP` | `Enum` | The [VARP](https://support.google.com/docs/answer/3094113) function |"]]