Sets in Tableau


As per my view I can say 3 types of sets.
  •         Constant Set
  •         Computed Set
  •         Combined Set

Constant Set:
Create set by selecting values of dimension. These values won’t change dynamically. Values which you selected will be IN Set, other values will be in OUT set.








































Computed Set:
This set we will create based on logic. For example, we will create Top 10 Customer by Sum(sales) or Customers whose sales more than 1 Million.


Combined Set:
This is nothing but combining two sets. To create combined set, both sets should be created on same dimension.

For Example, I want to see how many customers are there in Both Top 10 by Sum(sales) and Top 10 by sum(profit).

Step 1:
Create Top 10 Customers by Sum(sales) set. Right Click on Customer Name and create set.



Step 2:
Create Top 10 Customers by Sum(profit) set. Right Click on Customer Name and create set.



Step 3:
Right Click on “Top 10 Customer by Sum(sales)” set and select create combined set.



You can select how you want to show members from both sets. In this example, I would like to show Customers who are all there in both sets.