Tableau Filter Top 10. With each new field you add to the filters shelf in tableau you increase the complexity of the view and it becomes increasingly challenging to manage the combination of filters being used. The top or bottom condition can also be given through formula.
All others simply aggregates everything thats not included in the top 10. In the above example the filter restricts the data set to show top 10 records based on the sum of sales. Using a top filter i can quickly limit the view to show the top 10 products.
In the second drop down field to the left of by select top n ensure that the field to filter by usually a measure is specified in case sales as sum.
Click the value drop down menu and select the top customers 2 parameter. Which is great. Next we selected the top 10 records sales amount as the measure and sum as the aggregate function. We want to analyze sales by products.