Cumulative counting

Hi, 

My objective is to calculate some cumulative values and put them against some targets. The problem is that the once I use the dates (week ending) from the targets table the cumulative of the values (which are in a diffrent table) restarts. Do you have any ideea how this can be resolved? 

For example in the second table the values should be on 4th of june 175 and not 6, 6 is the actual counting of the values for that week but if I'm using the first table I won't be able to see all the future targets, they stop at the last date of the values.