Count Employees divided into groups

[omerbamba]

Hey, I have a little complicated problem, I'll try to be as clear as possible.

I manage work groups and employees, for that matter an employee can work in one or more work groups.

I want to build an aggregate table that gathers the workers as follows:
If an employee is work in only one group then it should be written under 1
If employee works in 2 different groups then it will be written under 2

In fact, I want to make sure that most of my employees are in one group and if there are employees who split into several groups, I want to identify them.

I hope I was clear, here's an example:

under dimension: 

[gf]

Could you provide some sample data?

[sunny_talwar]

The chart looks like it is doing what you want, isn't it? What is the issue?

[omerbamba]

It turns out that the information displayed there is incorrect

[omerbamba]

Sure,

WT Name, Employee Name

Feeder, Omer

Stacker, Omer

Feeder, Dana

Bronze, John

now it should display, 

Number of WT, Number of employees

1 , 2 (Dana and John)

2 , 1 (Omer)

hope you understand now

[sunny_talwar]

What is the correct output? Can you share a sample and provide what you are getting and what you expect to get?

[omerbamba]

The correct output for the data I wrote above:

Number of WT, Number of employees

1 , 2 (Dana and John)

2 , 1 (Omer)

let me know if you understand it now

Thx a lot!