TopOrBottomFilter

Represents a filter which can filter in cells in the upper or lower portion of the sorted values.

Constructors

new TopOrBottomFilter(a: number, b: IFilterable): TopOrBottomFilter

Returns TopOrBottomFilter

Properties

$t

$t: Type

Accessors

type

Gets or sets the type of the filter. TopValues or BottomValues to filter in the top or bottom N value in the list of sorted values; TopPercentage or BottomPercentage to filter in the top or bottom N percentage of values in the list of sorted values.

get type(): TopOrBottomFilterType

Returns TopOrBottomFilterType

set type(a: TopOrBottomFilterType): void

Parameters

a: TopOrBottomFilterType

Returns void

value

Gets or sets the number or percentage of value of values which should be filtered in.

get value(): number

Returns number

set value(a: number): void

Parameters

a: number

Returns void