1. Click the filter icon next to the axis icon, either for rows or for columns.
OR
1. Double-click the Rows or Columns folder in view explorer, and click the Browse button next to the Axis Filter field in the Rows or Columns Properties window.
2. Use the Expression window to edit the filter expression.
1. Click the filter icon next to the level.
OR
1. Double-click the level in view explorer, and click the Browse button 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.
A quick filter can be performed by selecting Member List then using the field at the bottom of the window to specify the level members. Separate by semicolons. Refer to members by what's used for the level display text.
Adjustments can be made using specific filter windows by selecting an option and clicking OK to access the window.
Member List - adjust the members in the Select or Advanced Select Members window, then click OK.
User List - select a list from the Select User List Filter window, then click OK.
Named Set - select a named set from the Select Named Set Filter window, then click OK.
Expression - adjust the filter expression in the Expression window, then click OK.
1. Click the filter icon 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.
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.
1. Click the filter icon 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.