It has been a while since I posted anything. Currently I am exploring Tableau Software, as I encounter some challenges as well, I decided to post those in a separate section.
This will be the first post.
I did not find a good example on how to build a waterfall chart. I could only find partially constructed ones. So from 0 building up to a total.
But not starting eg with total budget and then go to total Actual.
I have come up with the following solution, it might not be the best yet (I only started a week ago with Tableau at all), but it is something. The trick is: use 3 charts, 1 for total budget, 1 for the waterfall, and 1 for total actual, use a formula for total budget in window to start the running total from: Total(sum([Budget Profit])) + running_sum(sum([Profit])-sum([Budget Profit]))
See for dashboard in Tableau Public: view dashboard