Google Apps Script API
    Preparing search index...

    Interface PivotTable

    Access and modify pivot tables.

    interface PivotTable {
        addCalculatedPivotValue(
            name: string,
            formula: string,
        ): GoogleAppsScript.Spreadsheet.PivotValue;
        addColumnGroup(
            sourceDataColumn: number,
        ): GoogleAppsScript.Spreadsheet.PivotGroup;
        addFilter(
            sourceDataColumn: number,
            filterCriteria: GoogleAppsScript.Spreadsheet.FilterCriteria,
        ): PivotFilter;
        addPivotValue(
            sourceDataColumn: number,
            summarizeFunction: PivotTableSummarizeFunction,
        ): GoogleAppsScript.Spreadsheet.PivotValue;
        addRowGroup(
            sourceDataColumn: number,
        ): GoogleAppsScript.Spreadsheet.PivotGroup;
        getAnchorCell(): GoogleAppsScript.Spreadsheet.Range;
        getColumnGroups(): GoogleAppsScript.Spreadsheet.PivotGroup[];
        getFilters(): PivotFilter[];
        getPivotValues(): GoogleAppsScript.Spreadsheet.PivotValue[];
        getRowGroups(): GoogleAppsScript.Spreadsheet.PivotGroup[];
        getValuesDisplayOrientation(): GoogleAppsScript.Spreadsheet.Dimension;
        remove(): void;
        setValuesDisplayOrientation(
            dimension: GoogleAppsScript.Spreadsheet.Dimension,
        ): GoogleAppsScript.Spreadsheet.PivotTable;
    }
    Index

    Methods

    addCalculatedPivotValue addColumnGroup addFilter addPivotValue addRowGroup getAnchorCell getColumnGroups getFilters getPivotValues getRowGroups getValuesDisplayOrientation remove setValuesDisplayOrientation

    Methods

    Settings
    Member Visibility

    On This Page
    Methods