Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a problem - after select filter the accumulation is not full.
Without filter :
With filter :
As you can see it start to accumulate from 0 without considering previous days.
To calculate expression i use simple count. Any idea how to solve this ?
Thanks in advance.
Hi Jackub,
its happening because when we use a filter then it will disregard the value because those are become zero.
So you can try the following
Rangesum(sum(amount), 0, count({1} total dimension))
in your expression.
Hope it helps
With regards
Harshita Gaur