SheetXL - v1.0.2
    Preparing search index...

    Interface TopNOption

    interface TopNOption {
        filterVal?: number;
        limit?: number;
        percent?: boolean;
        sum?: boolean;
        top?: boolean;
    }
    Index
    filterVal? limit? percent? sum? top?
    filterVal?: number

    The actual cell value in the range which is used to perform the comparison for this filter.

    This is internal cache value used during filtering.

    limit?: number

    Top or bottom value to use as the filter param. For example "Filter by Top 10 Percent" or "Filter by Top 5 Items".

    Determined by Rule - Builtin 'Top10' is 10

    percent?: boolean

    Flag indicating whether or not to filter by percent value. A false value filters by number of items.

    With sum, the percent of the values' total rather than of their count.

    sum?: boolean

    Whether limit bounds the values' sum rather than their count: values are taken from the top (or the bottom) until their running sum reaches the limit, the one that reaches it included. A pivot table's Top 10 by Sum, and by Percent with percent.

    top?: boolean

    Flag indicating whether or not to filter by top order. A false value filters by bottom order.

    Settings
    Member Visibility

    On This Page
    Properties