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.