rolling sum of above values in text object

[Anonymous]

Hi,

my requirement is I have an field D

example :

D

1

2

3

4

5

6

7

If i click any number from 1 to 7 I want get sum of all above numbers.

for example : If I select 4 i want get sum of all above numbers of 4 i.e.,1+2+3=6

in a text object.

[#2]

Hi Sara,

Well 1 approach is that, sort the field in ascending order and then assign the selected value to a variable and use below expression:

=sum({<Column1={"<$(Variable1)"}>}Column1)

Thanks

[tresesco · Accepted solution]

May be like attached sample? PFA

=Sum({<D={"<$(=D)"}>}D)

[#4]

Sum({<FieldD={"<$(=Max(FieldD))"}>}FieldD)

[v_iyyappan]

Hi,

Try like this,

=Sum({$<D={"<$(=D)"}>}D)

by default it will show zero. when u select the "4" from D listbox. it will sum the 1+2+3= 6.

regards,

[jagan]

Hi,

Try this

Sum({<DimensionName={'<$(=Max(DimensionName))'}>}DimensionName)

Regards,

Jagan.