Accumulated values

[Silvia2]

Hello!
I want to create a Combo Chart.

As dimension I have a CREATED_DATE and as first measure I have number of sequences  created in that day  Count(distinct SEQ_NAME).

I added a second measure, a line, which displays number of sequences for the current day+number of sequences for previous day.

I tried to use RangeSum(Before(Count( distinct SEQ_NAME), 0, RowNo())) and it works partially as we can see below 6+4=10

But if I select a day, 28.01.2020 for example, it will not work.

Any suggestions how could I solve this?

[brunobertels]

Hi 

Replace Before by above in your mesure 

consider before only for crosstable 

regards 

[Silvia2]

Thank you for your response!
Still doesn't work.

The result is the same.