Hi
I want to make something like a table calculation in tableau prep. I've found online that i can use a self join to make cumulative totals.
The point is that it's now only a cumulative field, I use multiple fields for that.
I attached a file showing how the logics should work, but basicly, it is my current stock - order backlog + expected entries. If the result is negative, the result should be "0", because there is no such thing as negative stock.
Hi @ketlin fernandes kenauth
Ok, I had another look. A bit tricky to get Running Total in Prep but I created the below :
Take note I added an extra month with some extra values to test it a bit further.
The stock amount for each month will include the total stock of the previous month. If the previous month is negative the next month will start with a zero. Possibly there might be a simpler way to do this in prep but hopefully the attached is of some value.
Antonio
