You can exclude (remove) rows from the grid, if it is not required for your analysis. This feature is essentially a type of focus action that uses a 'not equal to' selection. You might want to exclude rows of data that you are not interested in or are not relevant to your analysis questions.
For example, suppose you are analyzing your customer sales for the last three months. Only four customers generated revenue above the target, so you want take your analysis further, without those top-performing customers in the picture.
Select the rows you want to exclude, then right-click the selection and click Exclude Selections.
The grid updates and excludes the selected rows. An exclamation mark along with the number of excluded rows displays on the corresponding dimension button and the status bar.
To undo the exclude action and include the data in the grid, click the X on the dimension button.
Note that the The Exclude Selections option is NOT available when using one or more OR conditions in an advanced search, as illustrated in the image below.
