Assembly: Pivot;
The IPivotFilter interface contains properties that determine data filtering parameters.
IPivotFilter
Data filtering parameters can be set by means of the FilterSetup command of the Express plugin.
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. |
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. | |
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: