Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
Hope someone can help me 🙂
Best regards
Anders
Have you looked here: The As-Of Table