sum over a dimension (YTD CALC)

[aresb]

Hi everyone,

i have this table

id_date	des_time_chiamate	cod_connid_3
01/01/2020	8	1
01/01/2020	9	1
01/01/2020	10	4
01/01/2020	11	4
01/01/2020	12	4
01/01/2020	13	7
01/01/2020	14	10
01/01/2020	15	6
01/01/2020	16	5
01/01/2020	17	8
01/01/2020	18	9
02/01/2020	8	10
02/01/2020	9	9
02/01/2020	10	8
02/01/2020	11	8
02/01/2020	12	5
02/01/2020	13	5
02/01/2020	14	7
02/01/2020	15	2
02/01/2020	16	9
02/01/2020	17	9
02/01/2020	18	9
03/01/2020	8	1
03/01/2020	9	9
03/01/2020	10	2
03/01/2020	11	4
03/01/2020	12	2
03/01/2020	13	6
03/01/2020	14	8
03/01/2020	15	1
03/01/2020	16	7
03/01/2020	17	5
03/01/2020	18	5
01/02/2020	8	10
01/02/2020	9	8
01/02/2020	10	1
01/02/2020	11	9
01/02/2020	12	6
01/02/2020	13	5
01/02/2020	14	4
01/02/2020	15	1
01/02/2020	16	2
01/02/2020	17	8
01/02/2020	18	4

If i filter on february 2020 i need to sum a YTD calculation over des_time_chiamate having a table like this, including jan 2020.

des_time_chiamate                                                                         (YTD_cod_connid_3)

8	27
9	24
10	27
11	36
12	24
13	29
14	36
15	30
16	29
17	38
18	36

How can i achieve this ? 

Thank You in advance

[G3S]

Is that the expected result you are showing in the 2nd table? are you able to share that calculation

[aresb]

Hi, g3s

yes im expecting that result.

sum({<des_time_chiamate={">=$(=Min(des_time_chiamate))<=$(=Max((des_time_chiamate)))"}>}cod_connid_3)