IPivotFilter

Assembly: Pivot;

Namespace: Prognoz.Platform.Interop.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
	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.
	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.
	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