Pivot Running Total with Begin and End Date

I'll try my best to explain my dilemma. I have a data sheet that contains begin and date. Can i create a pivot that shows a running total of how many I have each month considering my end date.


Id like to have a running total of my count in Pivot Actives after termination but in running total.

If i have 78 in Jan (C7) but then I have 18 terms in Jan my table should show a result of 60.

I've been creating 2 pivots then manually calculating the running total....so any help will be greatly appreciated. thanks