IPivotFilterSettings.ConditionValueB

Syntax

ConditionValueB: Variant;

Description

The ConditionValueB property determines the second value that is used in data filtering.

Comments

To use the property, it is required that:

  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 first value used for data filtering, use IPivotFilterSettings.ConditionValueA.

Example

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

See also:

IPivotFilterSettings