Cummulative Trending View

Hi,

I wanted calculate a cummulative view.

My table looks like below,

Loan ID	Date	Status
1	2-Jan	Contracted
1	3-Jan	PTD
2	4-Jan	Contracted
3	5-Jan	Contracted
4	1-Feb	Contracted
5	1-Feb	Contracted
5	2-Feb	PTD
2	1-Mar	PTD
6	2-Mar	Contracted
4	3-Mar	PTD

I wanted to calculate how many loans are there in Contracted and PTD status as of Jan, feb and march.

my table should look like this,

	Contracted count	PTD Count
Jan	2	1
feb	3	2
march	2	4

As of January, There are 3 loans, but for loan id 2 and 3, the last stage was Contracted for that month but for loan ID 1 the last stage is PTD. Therefore, the Contracted Count is 2 and PTD count is 1.

As of February, There are two new loans 4 and 5, the contracted count will 3 since loan id 2 and 3 from the previous month is still in Contracted and loan id 4 in feb is also in Contracted. Therefore the count is 3.

Similarly for PTD, loan id 1 from jan month and loan id 5 from feb is still in PTD. Therefore, the PTD Count is 2.

As of March, There is one new loan id 6, the contracted count will be 2 since Loan ID 3 and 6 still remains in contracted (Loan id 2 and 4 has moved to next stage PTD so it is excluded). Similarly for PTD, the count is 4 ( loan id 1 from jan, loan id 5 from feb and loan id 2 and 4 in march).

How do i calculate this?

my visual should look like