right click on customer -> create -> set
goto 'Condition' Tab - > paste the following formula to create a set for customers with Furniture as a department
Max(iif([Department] = "Furniture",1,0))=1
follow the above steps to create next set for office supplies
then COMBINE the set and choose the intersection option to get common customers in the department furniture and office supplies.
Combinations_solution.twbx 1,015.6 KB
Hi I did in the below way,
if [Both in Furniture and Office supplies] then "F and Office"
ELSEIF [Furniture set] then "Furniture"
ELSEIF [Office Supplies set] then "Office"
But i have 27 values in my requirement. I cant create those many sets to get all the combinations. Is there any other way to get this..
1 of 1 people found this helpful
While not exactly the same issue a colleague of mine recently wrote this blog post that might help: https://www.interworks.com/blog/malbacete/2016/07/26/actionable-venn-diagrams-tableau