0 votes
27 views
in Technology by (230k points)

What is Context Filter and show the steps on how to create the Context Filter Tableau?

1 Answer

0 votes
by (230k points)

Context Filters are applied to the data rows before any other filters. They are limited to views, but they can be applied on selected sheets. They define Aggregation and Disaggregation of data in Tableau

Step 1: Drag the subcategory dimensions to the row shelf and the measure sales to the column shelf. Now choose the horizontal bar chart as chart type and again drag the sub category dimensions to the filter shelf. Then we will get the following chart. 

Step 2: Right-click on the Sub-Category field in the filter shelf and go the Top fourth tab. Choose the option field, from the next drop-down and choose the option Top 10 by Sales Sum as shown in the following screenshot.

Step 3: Drag the dimension Category to the filter shelf. Give right-click on the general tab to edit and under that choose Furniture from the list. As you can see the result shows three subcategories of products.

Step 4: Right-click the Category: Furniture filter and select the option Add to Context. This produces the final result, which shows the subcategory of products from the category Furniture which are among the top 10 subcategories across all the products.

Related questions

0 votes
1 answer 76 views
0 votes
1 answer 43 views
0 votes
1 answer 25 views
0 votes
1 answer 93 views
0 votes
1 answer 17 views
0 votes
1 answer 34 views
0 votes
1 answer 62 views
0 votes
1 answer 54 views
0 votes
1 answer 77 views
0 votes
1 answer 38 views
0 votes
1 answer 41 views
0 votes
1 answer 34 views
0 votes
1 answer 29 views
0 votes
1 answer 23 views
0 votes
1 answer 27 views
0 votes
1 answer 17 views
0 votes
1 answer 27 views
0 votes
1 answer 18 views
...