Alternate rows sum in straight table

[#1]

Hi QV,

I have below data :

ID	Value
333	54
777	44
555	36
222	34
111	23
444	11
666	5

Now in a straight table based on rank(value) I need table should look like below :

ID	Value	rank	sum
333	54	1	118
777	44	2	118
555	36	3	118
222	34	4	118
111	23	5	118
444	11	6	118
666	5	7	118

Could anyone tell me how to write expr for sum above.

here sum is calculated by adding the odd rows i.e. if rank equals to 1/3/5/7... then I need to sum the Value.

Thanks,

Ananth

[tresB · Accepted solution]

Check attached sample.

Sum(total {<ID={"=Odd(Rank(Sum(Value)))"}>}Value)

[#3]

Thank you very much, this is what exactly I want.