IPivotFilterSettings

Assembly: Pivot;

Description

The IPivotFilterSettings interface is used to work with data filtering parameters.

Inheritance Hierarchy

          IPivotFilter

          IPivotFilterSettings

Comments

To get a object of this type, cast the IPivotFilter interface to IPivotFilterSettings.

Properties

  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