Rangesum and above issue

[#1]

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

[Kushal_Chawda · Accepted solution]

try this

=rangesum(above(total sum(Amount),0,RowNo(TOTAL)))