IPivotFilterSettings.ConditionValueA

Syntax

ConditionValueA: Variant;

Description

The ConditionValueA property determines the first value that is used in data filtering.

Comments

The property is relevant if:

  1. The IPivotFilterSettings.Enabled property is set to True.

  2. The IPivotFilterSettings.UseCondition property is set to True.

  3. The IPivotFilterSettings.ConditionType property takes any value from the PivotFilterType enumeration.

To determine the second value used for data filtering, use IPivotFilterSettings.ConditionValueB.

Example

The property use is given in the example for IPivotFilterSettings.ConditionType.

See also:

IPivotFilterSettings