SheetXL - v1.0.2
    Preparing search index...

    Interface DataFieldJSON

    A value of a pivot table: a field of the cache summarized by a function.

    interface DataFieldJSON {
        baseField?: number;
        baseItem?: number | "next" | "previous";
        field: number;
        name: string;
        numberFormat?: string | number;
        showDataAs?: string;
        subtotal?: string;
    }
    Index
    baseField? baseItem? field name numberFormat? showDataAs? subtotal?
    baseField?: number

    The field showDataAs compares against, by index.

    baseItem?: number | "next" | "previous"

    The item of baseField showDataAs compares against: by index, or the one before or after each item.

    field: number

    The field summarized, by index.

    name: string
    numberFormat?: string | number

    The number format of its values: a format code, or a built-in format's id; absent, General.

    showDataAs?: string

    How the value is shown, as OOXML spells it (percentOfTotal, difference, percentOfParentRow, rankAscending…); absent, as is.

    subtotal?: string

    The function, as OOXML spells it; absent, sum.

    Settings
    Member Visibility

    On This Page
    Properties