Say for example i have something like this returned in an analysis,
| Procedure Date | Report Date
| Procedure number
|
|---|
| 1/1/2019 | 5/1/2019 | 123456 |
but i would like to get something like this
| Calender Date | Procedure Date
| Report Date
| Procedure number
|
|---|
| 1/1/2019 | 1/1/2019 | | 123456 |
| 2/1/2019 | 1/1/2019 | | 123456 |
| 3/1/2019 | 1/1/2019 | | 123456 |
| 4/1/2019 | 1/1/2019 | | 123456 |
| 5/1/2019 | 1/1/2019 | 5/1/2019 | 123456 |
so essentially for any historic Calendar date i can determine how many null (unreported) procedures
thanks