RemoveFilterValue (Method)

Applies To:

TopLabel object, SideLabel object, Measure object

Description:

Removes an entire filter value, a single value based on a literal string value in a filter array, or a single value based on the position in a filter array.

Syntax:

Expression to remove a single value based on literal string value in filter array:

ActiveDocument.Sections["OLAPQuery"].Measures["Profit"].RemoveFilterValue()

Expression to remove a single value based on a literal string value in a filter array:

Expression.RemoveFilterValue(string SearchStringOrMemberNameOrNumberRowsColumnIndexORUserDefinedAttributeOrSubstitutionVariable)

Expression to remove a single value based on the position in a filter array:

ActiveDocument.Sections["OLAPQuery"].Measures["Profit"].RemoveFilterValue(number index)

Example:

The following example shows how to remove the filter value from the Line Name top label:

ActiveDocument.Sections["OLAPQuery"].TopLabels["Line Name"].RemoveFilterValue()