Rank: Member
Joined: 6/1/2017
Posts: 10
Location: Melbourne, Australia
|
Taken the data input below (fields are line number and amount)
1,5
2,15
3,10
4, 25
Is it possible to generate output with a running total as per below?
1,5,5
2,15,20 (5 + 15)
3,10,30 (20 + 10)
4, 25,55 (30 + 25)
Thanks
|
Rank: Advanced Member
Joined: 2/27/2009
Posts: 563
|
Sure, like this, using first-items (basically a specialized filter) and sum. File Attachment(s):
 example.zip (2kb) downloaded 33 time(s).
K101 attached the following image(s):
|
