There are three tabs in this window, used to filter any part of your view. Click to see descriptions of each tab.
Each level that is available (not hidden) in a view will display in the Levels tab of the Filters window. The level name will be followed by details about any filtering applied to the level.
If a level’s filter information has a series of dots “…” at the end of it, click the dots to activate a cursor. This enables you to scroll right and see the rest of the filter details for the level. In this example, the dots for a filtered RepBroker level were clicked. A cursor displays so you can scroll right and see the names of the rest of the members in the RepBroker member filter. |
|
Each level has icons available for adding, changing, or for clearing filters for the respective level.
|
|
OK – Click OK to apply all the changes that you made in the Filters window. Changes made on any tabs will be applied to the view. Cancel – Click Cancel to close the window without applying your changes. |
Each measure item included in the view will display in the Data tab of the Filters window. The measure item name will be followed by details about any filtering applied to the measure item.
|
|
Each measure item has icons available for adding, changing, or clearing filters for the respective measure item.
|
|
OK – Click OK to apply all the changes that you made in the Filters window. Changes made on any tabs will be applied to the view. Cancel – Click Cancel to close the window without applying your changes. |
Set up filters on the rows or columns axis using the Axis tab. Use axis filters when you need to set up filters involving multiple measure items or both measure items and attribute relationships. For example, use an axis filter to return all rows that fit the criteria of two different measure items -- such as all rows where Sales Units are greater than 1,000 and Profit Margin is less than 20%.
If axis filter information has a series of dots “…” at the end of it, click the dots to activate a cursor. This enables you to scroll right and see the rest of the filter details for the axis. |
|
Each axis has icons available for adding, changing, or clearing filters for the respective axis.
|
|
OK – Click OK to apply all the changes that you made in the Filters window. Changes made on any tabs will be applied to the view. Cancel – Click Cancel to close the window without applying your changes. |
|
- Example expressions are available to review or even copy and paste into your expression definition. |