Apply an Axis Filter

1.   Right-click the Rows or Columns axis icon (whichever axis you want to filter), and select Filter then Edit.

2.   Use the Expression window that displays to set up the expression for the filter, and then click OK.

     OR

1.   Double-click the Rows or Columns folder in view explorer (whichever axis you want to filter). The Rows or Columns Properties window displays.

2.   Click the Browse button next to the Axis Filter field.

3.   Use the Expression window that displays to set up the expression for the filter, and then click OK.

See also: Example Expressions for Filtering an Axis and Axis Filter Behavior When Levels are on Opposite Axis.