IPivotFilter

Assembly: Pivot;

Description

The IPivotFilter interface contains properties that determine data filtering parameters.

Inheritance Hierarchy

          IPivotFilter

Comments

Data filtering parameters can be set by means of the FilterSetup command of the Express plugin.

Properties

  Property name Brief description
Area The Area property determines the area, to which data filtering is applied.
Elements The Elements property determines the table element, by which filtering is executed.
Range The Range property returns the range, in which data filtering is executed.
SeparateHeaders The SeparateHeaders property determines whether filtering settings are used separately for rows and columns.

Properties inherited from IPivotFilterSettings

  Property name Brief description
AdditionalTableSourceSelSet The AdditionalTableSourceSelSet property returns the additional selection, according to which filtering is to be executed.
AttributeLinks The AttributeLinks property returns filtering parameters by dimension attributes links.
Condition The Condition property determines filtering expression parameters.
ConditionType The ConditionType property determines the condition type, according to which data is filtered.
ConditionValueA The ConditionValueA property determines the first value that is used in data filtering.
ConditionValueB The ConditionValueB property determines the second value that is used in data filtering.
Enabled The Enabled property determines whether data is filtered in table.
FilterSelection The FilterSelection property determines the selection, according to which displayed data will be filtered.
FilterSources The FilterSources property determines whether external filters are used for filtering.
KeepNeighbors The KeepNeighbors property determines whether data is filtered by levels of last dimension hierarchy.
KeepParent The KeepParent property determines whether owners of non-excluded elements are kept in the filtered table.
SupressEmpty The SupressEmpty property determines whether cells with empty values are filtered.
SupressNoNumeric The SuppressNoNumeric property determines whether cells with non-numeric values are filtered.
SupressZeros The SuppressZeros property determines whether cells with zero values are filtered.
UseAdditionalTableSource The UseAdditionalTableSource property determines whether filtering by additional selection that is different from that in the data source is used.
UseAttributesLinks The UseAttributesLinks property returns whether filtering by dimension attribute links is used.
UseCondition The UseCondition property determines whether data filtering by condition is used in table.
UseFilterSelection The UseFilterSelection property returns whether there is the selection, for which filtering is executed.
UseTransformationFilter The UseTransformationFilter property determines whether data filtering by formula is used.

See also:

Pivot Assembly Interfaces