To filter data by restricting the data returned:
To display the data filter panel, in the navigation panel, select Data Filtering.
Double-click in Data Restrictions.
Data restrictions apply standard data comparison operations (such as greater than, less than, and equal to) to data values.
If you define multiple criteria for a column, you can use the OR and AND operators to link the criteria.
From Column used for filter, select a column dimension member combination.
The member combinations listed here are determined by the members that you selected for the column dimensions. The data values for the specified column dimension members are used to compare data.
Optional: If you want to apply multiple data filters, repeat step 2 through step 5, and select And or Or.
The And option specifies that data must meet all criteria. The Or option specifies that the data must meet at least one of the criteria.
Next, you can sort the data, or apply the query now.
Applying Multiple Data Filters