How to to show Top N & Bottom N in single report.

Filters Types

Quick filters:  
Which are used to select the values dynamically, it enhance the user interaction with the report.

Filters:

Generally we use the filters to reduce the number of records present on the report or to show only required data on the report & to improve the performance.


Context Filter
It works like SLICER, which are used to filter the data all sheets of the workbook, When a worksheet queries the data source, it creates a temporary, flat table that is uses to compute the chart. This temporary table includes all values that are not filtered out by either the Custom SQL or the Context Filter.