SheetXL - v1.0.2
    Preparing search index...

    Interface PivotFilterJSON

    A filter of a pivot table: which items of a field show.

    A label filter tests each item's caption (the Display selector), a date filter its date (the Date selector, or a time period), and a value or top filter the item's total of a data field, within each item of the fields outside it.

    interface PivotFilterJSON {
        condition: ICondition.JSON;
        dataField?: number;
        description?: string;
        evalOrder?: number;
        field: number;
        id?: number;
        name?: string;
        useWholeDay?: true;
    }
    Index
    condition dataField? description? evalOrder? field id? name? useWholeDay?
    condition: ICondition.JSON
    dataField?: number

    A value or top filter: the data field whose total is tested, by index into JSON.dataFields.

    description?: string
    evalOrder?: number

    The order the filter applies in; absent, -1, the order listed.

    field: number

    The field filtered, by index.

    id?: number
    name?: string
    useWholeDay?: true

    A date filter that takes whole days, as a timeline sets it.

    Settings
    Member Visibility

    On This Page
    Properties