Hi !
I have the following database (with a lot of case numbers):
| Case_Number | Date | Area | Status |
| 279 | 14/7/2016 11:42:10 | Operaciones | Pendiente Operaciones |
| 279 | 15/7/2016 14:46:22 | Operaciones | Solicitud Reasignada por Operaciones |
| 279 | 15/7/2016 14:46:49 | Operaciones_UW | Pendiente Operaciones_UW |
| 279 | 18/7/2016 10:32:46 | UW | Pendiente UW |
| 279 | 18/7/2016 18:37:19 | Operaciones | Riesgo Aprobado UpGrade |
| 279 | 20/7/2016 9:42:59 | DDC | Riesgo Aprobado UpGrade - Campaña UpGrade |
| 279 | 25/7/2016 15:05:57 | Operaciones | Riesgo Aprobado UpGrade - Campaña UpGrade - No Contactado |
| 279 | 26/7/2016 16:44:11 | Operaciones | Riesgo Aprobado UpGrade - Campaña UpGrade - No Contactado |
| 280 | 15/7/2016 12:03:07 | Operaciones | Pendiente Operaciones |
| 280 | 18/7/2016 10:03:32 | Operaciones | Solicitud Reasignada por Operaciones |
| 280 | 18/7/2016 10:04:29 | Operaciones_UW | Pendiente Operaciones_UW |
| 280 | 18/7/2016 10:44:00 | UW | Pendiente UW |
| 280 | 18/7/2016 18:59:41 | Actuarial | Riesgo Extraprimado |
| 280 | 21/7/2016 15:04:29 | Operaciones | Riesgo Extraprimado |
| 280 | 21/7/2016 15:05:44 | Operaciones | Riesgo Extraprimado |
| 280 | 21/7/2016 16:17:19 | Call Center Telesales | Riesgo Extraprimado - Consulta al Cliente |
| 280 | 27/7/2016 12:01:40 | Operaciones | Riesgo Extraprimado - Consulta al Cliente - Aceptada |
| 280 | 27/7/2016 16:37:59 | Operaciones | Riesgo Extraprimado - Consulta al Cliente - Aceptada |
So a case enter in an area, then some procedures happen and goes to another area.
I need to summarize the database. Grouping by "Area" and in date, having the minimal date (the date a case number entered in the area). The problem is that a case number, can enter an Area, exit, go to another area and then come back. For example: Operaciones. I need to keep the sequence.
The result for the case "279" would be:
| Case_Number | Date | Area | Status |
| 279 | 14/7/2016 11:42:10 | Operaciones | Pendiente Operaciones |
| 279 | 15/7/2016 14:46:49 | Operaciones_UW | Pendiente Operaciones_UW |
| 279 | 18/7/2016 10:32:46 | UW | Pendiente UW |
| 279 | 18/7/2016 18:37:19 | Operaciones | Riesgo Aprobado UpGrade |
| 279 | 20/7/2016 9:42:59 | DDC | Riesgo Aprobado UpGrade - Campaña UpGrade |
| 279 | 25/7/2016 15:05:57 | Operaciones | Riesgo Aprobado UpGrade - Campaña UpGrade - No Contactado |
If you could help me with this I would really appreciate!
