Limiting the Items in Your Analysis
You can filter out unnecessary items using a variety
of techniques, depending on your business question, how you want
to compare your data, and how many items you must include in your analysis.
You can
- filter values to show only the items you want to view
- exclude items to eliminate unwanted information
- apply a top or bottom rule, which is useful when analyzing a large amount of data
- create a custom filter to limit the items shown to those that meet a specific criteria, such as products discounted by more than 10%
- remove rows or columns containing only missing values