Edit Existing Filters

Axis Filters

1.  Click the filter icon filterbutton.png next to the axis icon, either rowaxis.gif for rows or columnaxis.gif for columns.

     OR

1.   Double-click the Rows or Columns folder in view explorer, and click the Browse button browse_btn.gif next to the Axis Filter field in the Rows or Columns Properties window.

2.   Use the Expression window to edit the filter expression.

Level Filters

1.   Click the filter icon filterbutton.png next to the level.

OR

1.   Double-click the level in view explorer, and click the Browse button browse_btn.gif next to the Filter field in its Properties window.

2.   Use a quick filter or other options in the Select Filter Method window to edit the filter.

Measure Item Filters

1.   Click the filter icon filterbutton.png next to the measure item.

2.   Use the Measure Item Filter window to edit the filter.

OR

1.   Double-click the measure item in view explorer to open its Properties window.

2.   Use the Filter properties to edit the filter operator and value.

Relationship or Empty Filters

1.   Double-click the Rows or Columns folder in view explorer. The Rows or Columns Properties window displays.

2.   Adjust the Yes and No settings for the filter that you need to edit.

Note: In order for the Empty Filter property to be Yes, the Relationship Filter property must be Yes.

Total Filters

1.   Click the filter icon filterbutton.png next to the caption of the measure item in the Grand Total row or column.

2.   Use the Measure Item Filter window to edit the filter.