Hi Friends,
I have set of case IDs along with status per day in which i need to identify the distinct cases id with referred status only. The cases referred and closed on the same day should not be counted. Below is the sample data along with expected output.
Appreciate any suggestion
| ID | Status | Date |
| K1 | Referred | 02-11-2015 |
| K1 | Closed | 02-11-2015 |
| K2 | Referred | 02-11-2015 |
| K3 | Referred | 02-11-2015 |
| K3 | Referred | 02-11-2015 |
| K4 | Closed | 02-11-2015 |
| K5 | Open | 02-11-2015 |
| | |
Expected Output
| ID | Status |
| K2 | Referred |
| K3 | Referred |
