Transform Table to see how many people have how many instances

[Michael15]

I have a table:

Employee ID	Count Instances
100	2
101	3
102	2
103	4

I would like to transform the table to see following:

Count Instances	Count of Employee ID's
2	2
3	1
4	1

How could I achieva that?

[Chanty4u]

Just use 

Count ( employee id)

[Michael15]

I now have that in last column. But need to have summarized by Sum Instances. I would like to remove Employee ID and then see for example for 8 (sum Instances) 6, 10 = 4, 11 = 1 etc. Any idea?

[qv_testing]

Count(EmployeeID)

if you are expecting something else, provide some sample data and output

[vinieme12]

use Instances as dimension and count(distinct EmployeeID) as  measure

[Michael15]

Dear Vinieme12

My issue. The instances field is originally a field with general Instance = 1. So if employees have multiple instances, then the original sheet has multiple 1 for that employee. I needed to create a Count (Instances) field to sum instances by employee ID. However I can not add this count (instances) field to a table. It always bring me a red error. Any Idea to solve that?