Exclude data by using 'not equal to'
- Select Plus > Entity.
- Choose 'Not Equal To'".
- Select the entity or entities to exclude.
Edit an advanced search
If you do not save an advanced search as a favorite, it will remain active until it is deleted or cleared or the database is exited. Select the Search icon to edit existing rules or add more rules.
It is recommended that advanced search is the last step in your analysis. That is, select and focus on items prior to using advanced search.
Save as a favorite
You can save an advanced search as a favorite. This saves the rules you used to get the results, not the actual list of results returned. For example, an advanced search set to show declining customers might return a list of 45 declining customers. Saving this search as a favorite saves the search rules, not the 45 customers. The next time this favorite is opened, a different list of declining customers is likely to appear.
Locate declining customers
Find product sales that beat a target
Other ways to search for data
The search box allows you to type in text to locate data within your currently selected dimension. You can search for individual or multiple items. As a general rule, the search box only allows you to search whatever is currently shown on screen.
Right-clicking (or a long-tap on a device) in a cell in most modes presents a shortcut, also known as a filter on column, that allows you to perform a quick search of columns in the grid, based on data in that cell. This feature is sometimes referred to as an 'Advanced search shortcut', although it does not open the advanced search window.