Edit

Share via


PivotField.ClearManualFilter Method

Definition

Provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList and VisibleItemsList collections in OLAP PivotTables.

public:
 void ClearManualFilter();
public void ClearManualFilter ();
Public Sub ClearManualFilter ()

Remarks

This method is available for the PivotFieldObject in PivotTables and for the CubeField object in the OLAP PivotTables. Calling it for a PivotField in an OLAP PivotTable will return a run-time error.

After calling this method, the following collections are empty: HiddenItemsList, HiddenItems, VisibleItemsList, and VisibleItems.

Applies to