Table : Row Specifc Sum

[#1]

Hi,

I have a scenario where a calculation expression 'Summation'  depends on the 'Duration' figure;

   Raw data is something like :

Duration	Summation
1	20
2	30
3	10
4	20
5	10

  Requirement :

Duration	Summation
1	80
5	10

So that 'Summation' for  Duration '1' corrsponds to sum of 1 to 4 Duration , whereas 5,10,15,... should get its respective Summation Value.

I could get thru the 5,10,15,.. Summation by using Mod() function.

Would apprectiate any help on the above !

Cheers !

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[alexandros17]

Here it is my example