Enum PivotTableSummarizeFunction
Koleksiyonlar ile düzeninizi koruyun
İçeriği tercihlerinize göre kaydedin ve kategorilere ayırın.
PivotTablosuÖzetle işlevi
Pivot tablo verilerini özetleyen işlevlerin listesi.
Bir enum'u çağırmak için üst sınıfını, adını ve özelliğini çağırırsınız. Örneğin,
SpreadsheetApp.PivotTableSummarizeFunction.CUSTOM
.
Özellikler
Mülk | Tür | Açıklama |
CUSTOM | Enum | Özel işlev olan bu değer yalnızca hesaplanan alanlar için geçerlidir. |
SUM | Enum | SUM işlevi |
COUNTA | Enum | COUNTA işlevi |
COUNT | Enum | COUNT işlevi |
COUNTUNIQUE | Enum | COUNTUNIQUE işlevi |
AVERAGE | Enum | AVERAGE işlevi |
MAX | Enum | MAX işlevi |
MIN | Enum | MIN işlevi |
MEDIAN | Enum | MEDIAN işlevi |
PRODUCT | Enum | PRODUCT işlevi |
STDEV | Enum | STDEV işlevi |
STDEVP | Enum | STDEVP işlevi |
VAR | Enum | VAR işlevi |
VARP | Enum | VARP işlevi |
Aksi belirtilmediği sürece bu sayfanın içeriği Creative Commons Atıf 4.0 Lisansı altında ve kod örnekleri Apache 2.0 Lisansı altında lisanslanmıştır. Ayrıntılı bilgi için Google Developers Site Politikaları'na göz atın. Java, Oracle ve/veya satış ortaklarının tescilli ticari markasıdır.
Son güncelleme tarihi: 2025-07-26 UTC.
[null,null,["Son güncelleme tarihi: 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,["# Enum PivotTableSummarizeFunction\n\nPivotTableSummarizeFunction\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\n### Properties\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 |"]]