Need to add values based on before two dates

[praveenkumar_s]

Hi friends,

I have date and cost column. all i need is just one more field which consists of total cost for current day + last two days in load script.

Please find the attached screenshot below.

Please let me know in case of any clarifications.

[shiveshsingh]

Use this bro

F:load Date, Cost, rangesum(Cost,Peek(Cost) ,Peek(Cost,-2)) as Total

[eduardo_dimperio]

Well you've 3 answer using Peek(), just check one of then and mark the right answer pls

[praveenkumar_s]

thanks for your continuous suggestion. finally i got that..

[praveenkumar_s]

suppose if we want to add n date (eg- last 8 dates) means, how can we achieve that simply?