Narrow the data shown in a view using Filters. Filters are defined by selecting specific dimension members or a range of measure values. For example a view showing product sales in four different regions may be filtered to only show three regions. In this case, the filter is created by selecting the specific regions to show. Another example may be to filter the same view to only show sales between $5000 and $20,000. For this filter a range of values is defined. In addition to these basic filters you can create complex computed filters to show the top 10 products based on sales, all products sold in the last 30 days, and so on.
All fields that are filtered display on the Filters shelf, making it easy to determine the data that has been removed from the view. Filters are applied to the view in the order they appear on the Filters shelf. However, by default filters are evaluated independently from each other, which means each filter is evaluated against the entire underlying data source and other filters are not taken into account. When working with independent filters, the order on the filters shelf does not change the results.
- Adding Filters
- Sharing Filters
- Context Filters
- Calculation Filters