@jsfkit/types
    Preparing search index...

    Type Alias PivotFilter

    An advanced filter applied to a pivot table field.

    Pivot filters implement features like "Show Top 10", "Show items where value > X", and date-based filters.

    type PivotFilter = {
        autoFilter?: {
            filterColumns?: PivotAutoFilterColumn[];
            ref?: CellRange;
        };
        description?: string;
        evalOrder?: integer;
        fieldIndex: integer;
        id: integer;
        iMeasureFld?: integer;
        iMeasureHier?: integer;
        mpFld?: integer;
        name?: string;
        stringValue1?: string;
        stringValue2?: string;
        type: PivotFilterType;
    }
    Index

    Properties

    autoFilter? description? evalOrder? fieldIndex id iMeasureFld? iMeasureHier? mpFld? name? stringValue1? stringValue2? type

    Properties

    autoFilter?: { filterColumns?: PivotAutoFilterColumn[]; ref?: CellRange }

    Auto-filter criteria that implement this pivot filter.

    Type Declaration

    description?: string

    Description of the filter.

    evalOrder?: integer

    Evaluation order for multiple filters. Lower values are evaluated first.

    0
    fieldIndex: integer

    Index of the pivot field this filter applies to.

    id: integer

    Unique identifier for this filter within the pivot table.

    iMeasureFld?: integer

    Measure field index used for value-based filters.

    iMeasureHier?: integer

    Measure hierarchy index (OLAP).

    mpFld?: integer

    Member property field index (OLAP).

    name?: string

    Display name for the filter.

    stringValue1?: string

    First string value for comparison-based filters.

    stringValue2?: string

    Second string value for between/not-between filters.

    type: PivotFilterType

    The filter type.

    Settings

    Member Visibility

    On This Page

    Properties