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
8 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 13,860 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
278 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,200 points
18 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,470 points
96 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
• 830 points
29 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,200 points
17 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,470 points
13 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
• 13,860 points
38 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
• 13,860 points
10 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
• 13,860 points
43 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
• 13,860 points
35 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.