I have information that contains Requestno, Step and a Date. I want to be able to count how many Requestno there are in step 1, 2 and so on, by the last date in each month.
My data looks like this:
Requestno, Step, Date
1, 1, 2015-10-20
1, 2, 2015-10-25
1, 4, 2015-11-02
2, 1, 2015-10-22
2, 2, 2015-10-26
2, 5, 2015-11-03
2, 6, 2016-01-12
3, 1, 2015-11-15
3, 2, 2015-12-04
3, 3, 2016-01-04
So in this case, by 2015-10-31 there are 2 Requestno in step 2 (no 1 and 2) and by 2015-11-30 there are one Requestno in step 1, one in step 4 and one in step 5.
So I need a sort of MasterCalender to fill out all dates all the way onto today and for each date show which step the Requestno is in and be able to count them.
