Excel.PivotValueFilter interface

Package:

excel

Configurable template for a value filter to apply to a PivotField. The condition defines what criteria need to be set in order for the filter to operate.

Remarks

[ API set: ExcelApi 1.12 ]

Properties

comparator	The comparator is the static value to which other values are compared. The type of comparison is defined by the condition. For example, if comparator is "50" and condition is "greaterThan", all item values that are not greater than 50 will be removed by the filter.
condition	Specifies the condition for the filter, which defines the necessary filtering criteria.
exclusive	If true, filter excludes items that meet criteria. The default is false (filter to include items that meet criteria).
lowerBound	The lower-bound of the range for the between filter condition.
selectionType	Specifies if the filter is for the top/bottom N items, top/bottom N percent, or top/bottom N sum.
threshold	The "N" threshold number of items, percent, or sum to be filtered for a top/bottom filter condition.
upperBound	The upper-bound of the range for the between filter condition.
value	Name of the chosen "value" in the field by which to filter.

Property Details

comparator

The comparator is the static value to which other values are compared. The type of comparison is defined by the condition. For example, if comparator is "50" and condition is "greaterThan", all item values that are not greater than 50 will be removed by the filter.

comparator?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.12 ]

condition

Specifies the condition for the filter, which defines the necessary filtering criteria.

condition: Excel.ValueFilterCondition | "Unknown" | "Equals" | "GreaterThan" | "GreaterThanOrEqualTo" | "LessThan" | "LessThanOrEqualTo" | "Between" | "TopN" | "BottomN";

Property Value

Excel.ValueFilterCondition | "Unknown" | "Equals" | "GreaterThan" | "GreaterThanOrEqualTo" | "LessThan" | "LessThanOrEqualTo" | "Between" | "TopN" | "BottomN"

Remarks

[ API set: ExcelApi 1.12 ]

exclusive

If true, filter excludes items that meet criteria. The default is false (filter to include items that meet criteria).

exclusive?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]

lowerBound

The lower-bound of the range for the between filter condition.

lowerBound?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.12 ]

selectionType

Specifies if the filter is for the top/bottom N items, top/bottom N percent, or top/bottom N sum.

selectionType?: Excel.TopBottomSelectionType | "Items" | "Percent" | "Sum";

Property Value

Excel.TopBottomSelectionType | "Items" | "Percent" | "Sum"

Remarks

[ API set: ExcelApi 1.12 ]

threshold

The "N" threshold number of items, percent, or sum to be filtered for a top/bottom filter condition.

threshold?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.12 ]

upperBound

The upper-bound of the range for the between filter condition.

upperBound?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.12 ]

value

Name of the chosen "value" in the field by which to filter.

value: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.12 ]