Using Top in filter.

0 votes
Hi, I'm new to Tableau. How to find the top 5 profitable products and arrange them in ascending order based on their number of sales by using top filter.
Apr 30 in Tableau by tejas
26 views

1 answer to this question.

0 votes

Hi Tejas,

The top filter is used to filter all items from the field domain with top N values that follow the order on aggregation(max, sum, min, avg) of fields.

Follow the below steps:

1. Drag and drop the products in the filter shelf.

2. Now go to Top pane in the edit filter dialog box and select Profit and enter N value as 5.

3. Drop product in row shelf and sales in the text field.

4. Now right click on product and cick on sort.

5. Click on x and close the sort dialog box.

Hope it helps you.

answered Apr 30 by Cherukuri
• 31,840 points

Related Questions In Tableau

0 votes
1 answer

How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

answered Apr 11, 2018 in Tableau by xyz
• 1,550 points
864 views
0 votes
1 answer

How to add filter to show latest two dates in tableau?

Steps for filtering based on the most ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
47 views
+1 vote
1 answer

How to perform top N fields with nested sort in tableau

You can use the following steps: Sort 'State' ...READ MORE

answered Aug 3, 2018 in Tableau by Atul
• 5,530 points
545 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
71 views
0 votes
1 answer

Is it possible to apply filter just to one of the measures

Hey @Ghost, Why don't you use Level of Detail ...READ MORE

answered Apr 17, 2018 in Tableau by Atul
• 10,240 points
47 views
0 votes
1 answer

Getting incorrect tooltip while toggling through quick filter

I think what you want to ask ...READ MORE

answered Jun 26, 2018 in Tableau by Atul
• 5,530 points
32 views
0 votes
1 answer

Create global filter from single/multiple data source to multiple data sources on dashboard.

Hi Sindhu, You can use filters from worksheets in ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 31,840 points
77 views
0 votes
1 answer

create filter from multiple data sources

Hi Nithin, 1. You can perform full outer ...READ MORE

answered Mar 13 in Tableau by Cherukuri
• 31,840 points
27 views
0 votes
1 answer

How to add parameter and calculated field filter in tableau?

Hi Sindhu,  You cannot add parameter as a ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 31,840 points
208 views
0 votes
1 answer

Hide value in filter - Tableau

Hi Varsha, Fields, Parameters are hidden generally hidden whereas calculative ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 31,840 points
212 views