Forum Discussion
Cant get Matrix report as needed
Hi,
I have explained issue below, help is appreciated
I have data like
| EmpID | Taining | Status |
| 1 | PhysicalSecurity | Dropped |
| 1 | PhysicalSecurity | Completed |
| 1 | Client Relation | In Progress |
| 2 | PhysicalSecurity | In Progress |
| 2 | PhysicalSecurity | Dropped |
| 3 | Client Relation | In Progress |
| 3 | Client Relation | Dropped |
| 3 | Client Relation | Incomplete |
| 3 | Client Relation | No Show |
| 3 | PhysicalSecurity | Dropped |
| 3 | PhysicalSecurity | Completed |
| 4 | PhysicalSecurity | In Progress |
| 4 | PhysicalSecurity | Dropped |
| 4 | Client Relation | In Progress |
| 4 | Client Relation | Dropped |
| 11 | PhysicalSecurity | Dropped |
| 11 | PhysicalSecurity | Completed |
| 11 | Client Relation | In Progress |
| 12 | PhysicalSecurity | In Progress |
| 12 | PhysicalSecurity | Dropped |
| 13 | Client Relation | In Progress |
| 13 | Client Relation | Dropped |
| 13 | Client Relation | Incomplete |
| 13 | Client Relation | No Show |
| 13 | PhysicalSecurity | Dropped |
| 13 | PhysicalSecurity | Completed |
| 14 | PhysicalSecurity | In Progress |
| 14 | PhysicalSecurity | Dropped |
| 14 | Client Relation | In Progress |
| 14 | Client Relation | Dropped |
i need report like
| Training | Completed | In Progress | Incomplete | Dropped | No Show | Totals |
| PhysicalSecurity | 4 | 4 | 0 | 0 | 0 | 8 |
| Client Relation | 0 | 6 | 0 | 0 | 0 | 6 |
| Totals | 4 | 10 | 0 | 0 | 0 | 14 |
This is because employee can attempt multiple times ,
So, need to get counts using below logic
Get Distinct Emplyee ID Count for Completed Status
Exclude Emplyee ID for completed and get Distinct Emplyee ID Count for In Progress Status
Exclude Emplyee ID for completed, In Progress and get Distinct Emplyee ID Count for Incomplete Status
Exclude Emplyee ID for completed, In Progress, Incomplete and get Distinct Emplyee ID Count for Dropped Status
Exclude Emplyee ID for completed, In Progress, Incomplete,Dropped and get Distinct Emplyee ID Count for No Show Status
No Replies