Quick Filter: Quick Filter Creates an interactive selection panel on the right top corner of the data view. We can implement Quick Filter on Dimensions or Measures. The interactive selection panel provides the options based on the source data.
Example: Quick Filer on Order Date with Yearly Consolidation provides the list of YEARS available from SOURCE DATA for user selection.
Global Filter: Global Filter helps to share the same filter using the same source data across multiple (or) all worksheets within a workbook. We can apply a global filter for all the worksheets using the same data (or) It can be applied to only selected worksheets.
Example: Filter with Complex calculation in one worksheet can be applied to some other worksheet which using the same source data to avoid repetitive work.
Context Filter: Context Filter helps to pass the criteria of the filter from one level to another related level.
Example: Top 10 Customers in the country by their purchases; here the context is ‘Top 10’. We can pass this context to know ‘Top 10’ Customers by Purchases in a State within the same country.
Filter at Source: After connecting with the data source, filtering the data before getting into the worksheet is called filtering at the source. This helps in improved performance because the unwanted data eliminated.
Example: Selecting only one year worth of data from a few years of historical data after connecting with the source
Filter on Measure: This filter provides options – a range of values, at least, at most and special. We can select any option that helps to select the right data or eliminate the unwanted data. A special option is to deal with Null values.
Example: Filter on Sum of Sales.
Filter on Dimension: This filter provides options – General, Wildcard, Condition and Top/Bottom. We can select any option that helps to select the right data or eliminate the unwanted data. We can also create own formula then use it in this filter options – Condition and Top/Bottom for the data selection needs. Condition and Top/Bottom provides a channel from dimension to measure to get the required data.
Example: Filter on Order Date then selecting sales through dimension.