I have the following data from the status logs:
Assume today is Dec 4th
| ID | Date | Status |
|---|
| A | 12/4/2012 | Docs Received |
| A | 12/3/2012 | Docs Sent |
| A | 12/2/2012 | Docs Requested |
| B | 12/2/2012 | Docs Sent |
| B | 11/1/2012 | Docs Requested |
| C | 12/4/2012 | Docs Requested |
| D | 12/3/2012 | Docs Requested |
How can I get the counts as in below report?
| Status | As of Yesterday | Additions | Substraction | As of Today |
|---|
| Docs Received | 0 | 1 | 0 | 1 |
| Docs Sent | 2 | 0 | 1 | 1 |
| Docs Requested | 2 | 0 | 0 | 2 |
Thanks,
Dinesh.
