How to sum value in column with a condition in other column
Hi, I'm having trouble calculating the sum of one column based on the condition of another column. My dataset (an example below) contains rows that represent inventory movements, movements can be of three types: load, unload, setup. In the case of a setup type row it represents an inventory type row, therefore an existence at a precise date, with this condition I have to calculate the stock starting from the last setup type row onwards.
the final quantity of product 001 will be 11.
could you show me a solution to calculate this sum?