HI all expert!
I have this set of data,
| Contact Person | Contact Number | COMPANY |
|---|
| MA | 11111111 | ABC |
| MA | 11111111 | DEF |
| MA | 22222222 | GHI |
| MB | 22222222 | JIL |
| MC | 33333333 | MNO |
| MD | 33333333 | PQR |
| ME | 33333333 | STU |
| ME | 33333333 | VWX |
| ME | 3333333 | YZA |
I would like to find out the number of cases where same contact person, multiple company. So in this set of data, it will be 2 (MA & ME both represent multiple company).
I would not like to touch my scripting as much as possible. How can I expression in my KPI to show the number of case.
Regards,
Jia
