I hope this is the solution you are looking for. If not, do share the details of the expected output in numbers to get better understanding.
Check the attachmet of Tableau workbook in 10.1 Version.
Burger.twbx 44.2 KB
Thank-you so much for the reply. I will help you understand the problem.
1. Find count of employees in Burger king only ---Found (worksheet 1)
2. Find count of employees in McDonalds only ---Found (worksheet 2)
3. Find employees in both------------------------------Found (worksheet 3)
So 3 employees were foudn in both Emp ids : 1 , 3, 8
Now I want to find the count of employees found in both but where McDonald had a food item.
So employees 1, 3 ,8 are found in both but I want only the highlighted employees that have Burger king hrs= 0 against them.
Also can you reattach your workbook; I wasnt able to open it.
2 of 2 people found this helpful
The solution is to create sets on Emp id. Right Click on Emp id and Create sets.
In the condition tab, add formula
For Emp id in both:
SUM[(Burger king hrs)]> 0
SUM[(Mc Donalds hrs)]>0
Once the set is created, drag it to filters. Create another filter for Burger king hrs= 0 and drag it to filters.
Drag Emp id to text area and choose measure to count distinct. Drag Emp id to Rows
This will give you all the employees that satisfy Burger king hrs= 0 for employees found in both.
Now to find total count of these employees , click on Analysis >> Totals >>Show Column grand totals.