Cumulative sum in qlik Sense expression

[hamzabob1]

Hello Everyone,

I am trying to calculate cumulative sum in a Straight table in Qlik Sense which has 3 dimensions; Date , code and Plant.

What I want is, Quantity values should be cumulatively summed in Straight table for every day.

i am getting the desired output on code selection but i want to get the correct out put without any selection.

Current table:

output Required:

stock Logic:For 11/2/2020( First day stock+2nd day quantity)and so on.

@sunny_talwar 

Please suggest me any solution if anyone of you gone through the same problem.

Thanks.

Hamza

[Ksrinivasan]

hi,

you can rearrange column order,

first material code then date,

ksrinivasan

[hamzabob1]

Hi vasan,

thanks for your rpl but customer want in this  format only.

Regards,

Hamza