Acumulative costs by months Set analysis

[lomi89]

Hello, I would like to create an acumulative field with cost on Set Analysis. I have to aggregate the cost by date and this date is filtered:

months: =DATE(IF(DATE1>=AddMonths(monthstart(today()),-12) and DATE1<= AddMonths(today(),-1), MONTHSTART(DATE1)),'MM-YY')

Cost:  =rangesum(above(MT_COUT_SHAM,0, MONTHSTART(DATE1)))

Whith this formulas I can't do it:

Thank you very much

[anat · Accepted solution]

rangesum(above(sum(MT_COUT_SHAM),0,12))