Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to everyone!
I have a db table like:
Yellow cells is have to be calculated.
ToBuy = Ordered - Remain
Remain = Remain (in previous month) - Ordered (in previous month) + ToBuy (in previous month)
So, the result should be like:
Please, help to make it in load script or give please a hint to find the solution. Thanks!
P.S. I tried to make it in expression, but I couldn't do it in pivot table where I put in columns "Month-Year".
Thanks!
I think the only way is to make Looping.
But I don't know how to make it in right way. Please help!
You could use previous() or peek() to catch the values from the previous records - a very good explanation could you find here: Peek() or Previous() ? and in your case, something like:
previous(Remain) - previous(Ordered) + previous(ToBuy)
- Marcus