T SQL Cte Previous record calcuation
Test something like:

Open_Stk Calc = SUM(COALESCE(Open_Stk + Replen, 0)) OVER (PARTITION BY sku ORDER BY ShopPrioirty)


Or divide to two SUMs to avoid COALESCE() usage. Edit PARTITION expression if needed. - akina