@jsfkit/types
    Preparing search index...

    Type Alias PivotAutoFilterColumn

    A filter column within an auto-filter, specifying the filter criteria for a single column.

    type PivotAutoFilterColumn = {
        colId: integer;
        customFilters?: { and?: boolean; filters: PivotCustomFilterCriterion[] };
        top10?: {
            filterVal?: number;
            percent?: boolean;
            top?: boolean;
            val: number;
        };
    }
    Index

    Properties

    colId customFilters? top10?

    Properties

    colId: integer

    The 0-based column index within the auto-filter range.

    customFilters?: { and?: boolean; filters: PivotCustomFilterCriterion[] }

    Custom filter criteria (up to two conditions with AND/OR logic).

    Type Declaration

    • Optionaland?: boolean

      Whether the two filters are combined with AND (true) or OR (false).

      false
    • filters: PivotCustomFilterCriterion[]
    top10?: { filterVal?: number; percent?: boolean; top?: boolean; val: number }

    Top-10 filter: show top/bottom N items by count, percent, or sum.

    Type Declaration

    • OptionalfilterVal?: number

      The actual cutoff value used for filtering.

    • Optionalpercent?: boolean

      Whether filtering is by percent (true) or count (false).

      false
    • Optionaltop?: boolean

      Whether to show the top items (true) or bottom items (false).

      true
    • val: number

      The number of items (or percent) to show.

    Settings

    Member Visibility

    On This Page

    Properties