Interface PivotFieldSpec

A pivot value/row/column/filter field for Sheet.addPivotTable.

interface PivotFieldSpec {
    sourceColumn: number;
    role: number;
    aggregate?: number;
    name?: string;
}

Properties

sourceColumn: number

0-based source column (relative to the source range's first column).

role: number

aggregate?: number

A PivotAggregate (only meaningful for value fields).

name?: string

A custom display label.