Calculation using previous row value

[#1]

Dear Experts

I need to calculate the column “Risky stock” as shown in the attached excel file.

The other columns I have them loaded from SQL.

Any help?

[preminqlik]

should reset for only item level ?

or

both company and item level ?

[#3]

Actually yes for both company and item.