4 Replies Latest reply: Jul 9, 2013 3:02 AM by Utsav Vachharajani RSS

    Count If / Aggr Issue

      Hi All,

       

      I have a table with unique employee id and count of cases in front of them.

       

      ManagerId     Emp ID          Cases

           A               1                        5

           A               2                       10

           A               3                       5

           A               4                       20

           A               5                       5

       

       

      And i want to create the following :

       

      ManagerID      Count of EMPID with Count of Cases =3

      A                                        3

       

       

      I want to

      Please help me out with the same...

       

      Regards,

      Utsav