Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have below data set
ID | Amount | Type |
1 | 10 | A |
2 | 20 | A |
3 | 0 | B |
4 | 2 | B |
5 | 11 | B |
I am creating straight table
Dimension - ID
Expression = rangesum(above( sum(Amount),0,RowNo()))
Above expression works well for single dimension, but as soon as I am adding another dimension i.e Type, values are changing.
I want the same values when I add any other dimension
try this
=rangesum(above(total sum(Amount),0,RowNo(TOTAL)))