I have a scenario to solve as per below.
| AA |
Accepted |
TKT1 |
| AA |
Informed |
TKT2 |
| BB |
Assigned |
TKT3 |
| BB |
Pending Supplier |
TKT4 |
| BB |
Informed |
TKT5 |
| BB |
Informed |
TKT6 |
| CC |
Informed |
TKT7 |
| CC |
Pending Supplier |
TKT8 |
| DD |
Pending Customer |
TKT9 |
The output should be like below
|
AA has 2 tickets whereas Accepted 1 and Informed 1 and the incidents are TKT1, TKT2
|
|
BB has 4 tickets whereas Assigned 1, Pending Customer 1 and Informed 2 and the incidents are TKT3, TKT4, TKT5, TKT6
|
|
CC has 2 tickets whereas Informed 1 and Pending Supplier 1 and the incidents are TKT7, TKT8
|
|
DD has 2 tickets whereas Pending Customer 1 and the incidents are TKT9
|
