How to add commulative function on dremio dataset

[Vikash_Singh]

Hi,

I have requirement to apply commulative way on the dataset column like lets say i have following column

DailyProduced CommulativeProduced
10 10
3 13
5 18

so in commulative each Daily Product added with Previous Commulative Product,How to create this type of extra field in dataset so that i can acheive in analytics charts

i have xls file for the sample refrence,is in drmeio possible through window functions

https://docs.dremio.com/sql-reference/sql-functions/analytic.html

[Vikash_Singh]

I am trying like this but not able achive this

[dacopan]

please not duplicate post.

already answer in Adding new Column containing values based on condition