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.
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.
UseTransformationFilter The UseTransformationFilter property determines whether data filtering by formula is used.

See also:

Pivot Assembly Interfaces