Open the link to Book1 found on the desktop. Open Disciplines worksheet.

Open the link to Book1 found on the desktop. Open Disciplines worksheet.

Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.

View Answer

Answer: To filter the table to show the members of the Top10 set and the Bottom10 set, you need to do the following steps:

Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Disciplines worksheet.

Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.

Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.

Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.

Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.

Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/sets.htm

https://help.tableau.com/current/pro/desktop/en-us/filtering.htm