Cumulative counting

[floarea_pitu]

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.  

[v-zhangti]

Hi, @floarea_pitu 

Is it possible to provide some of the source data for testing? Is that a matrix view shown in your picture?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[floarea_pitu]

Hi, unfortunately I can't upload data, and yes is a matrix visual ....