Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a measure that I'm using rangesum, above, and the result is ok. But when I select one dimension in my pivot table the return is 0.
I have dimension, period, city and the column as category
If I filter the first dimension Period, the result of line that I had select is 0
my expression:
rangesum(below(sum({<period_2-={'$(=min(period_2))'}>}[value]),0,RowNo()))
I trid to ignore selction, but the result is different
rangesum(below(sum({<period_2-={'$(=min(period_2))'},period,period_2,city,category>}[value]),0,RowNo()))
Try as below
=Rangesum(
AGGR({<period,period_2,city,category>}
below(sum({<period_2-={'$(=min(period_2))'}>}[value]),0,RowNo())
,period,period_2,city,category)
)
thanks for your answer...
Now, when I select i can see the value that I selected, this is good, but I think this happen because Include {1} in the min period
The problem now is, that is not accumulating more.
I remove all dimension, to test I'm working just with period.
I dont know, how to do cumulative and dont show 0 when select value
Rangesum(
Aggr({<period>}
BELOW(sum({< period-={'$(=min({1}period))'}>} [value])
,0,
RowNo())
,period)
)
selecting, with your suggestion:
without selecting: Is not accumulating more
Removing the aggr, now is cumulative, but when I select the value to 01/02/2022 is not acumulative
Rangesum(
//Aggr({<period>}
BELOW(sum({< period-={'$(=min({1}period))'}>} [value])
,0,
RowNo())
//,period)
)