Google Apps Script API
    Preparing search index...

    Interface PivotGroup

    Access and modify pivot table breakout groups.

    interface PivotGroup {
        addManualGroupingRule(
            groupName: string,
            groupMembers: any[],
        ): GoogleAppsScript.Spreadsheet.PivotGroup;
        areLabelsRepeated(): boolean;
        clearGroupingRule(): GoogleAppsScript.Spreadsheet.PivotGroup;
        clearSort(): GoogleAppsScript.Spreadsheet.PivotGroup;
        getDimension(): GoogleAppsScript.Spreadsheet.Dimension;
        getIndex(): number;
        getPivotTable(): GoogleAppsScript.Spreadsheet.PivotTable;
        getSourceDataColumn(): number;
        hideRepeatedLabels(): GoogleAppsScript.Spreadsheet.PivotGroup;
        isSortAscending(): boolean;
        moveToIndex(index: number): GoogleAppsScript.Spreadsheet.PivotGroup;
        remove(): void;
        removeManualGroupingRule(
            groupName: string,
        ): GoogleAppsScript.Spreadsheet.PivotGroup;
        resetDisplayName(): GoogleAppsScript.Spreadsheet.PivotGroup;
        setDisplayName(name: string): GoogleAppsScript.Spreadsheet.PivotGroup;
        setHistogramGroupingRule(
            minValue: number,
            maxValue: number,
            intervalSize: number,
        ): GoogleAppsScript.Spreadsheet.PivotGroup;
        showRepeatedLabels(): GoogleAppsScript.Spreadsheet.PivotGroup;
        showTotals(showTotals: boolean): GoogleAppsScript.Spreadsheet.PivotGroup;
        sortAscending(): GoogleAppsScript.Spreadsheet.PivotGroup;
        sortBy(
            value: GoogleAppsScript.Spreadsheet.PivotValue,
            oppositeGroupValues: any[],
        ): GoogleAppsScript.Spreadsheet.PivotGroup;
        sortDescending(): GoogleAppsScript.Spreadsheet.PivotGroup;
        totalsAreShown(): boolean;
    }
    Index

    Methods

    addManualGroupingRule areLabelsRepeated clearGroupingRule clearSort getDimension getIndex getPivotTable getSourceDataColumn hideRepeatedLabels isSortAscending moveToIndex remove removeManualGroupingRule resetDisplayName setDisplayName setHistogramGroupingRule showRepeatedLabels showTotals sortAscending sortBy sortDescending totalsAreShown

    Methods

    Settings
    Member Visibility

    On This Page
    Methods