To do this, place Year on the columns shelf (make sure it is discrete). Place Revenue on the rows shelf. Right click on it and select Quick Table Calculation-->Running Total.
Create a calculated field:
Place this on the size shelf (make sure the mark type is a Gantt bar). Finally, place Product on the color shelf.
Hope this helps!
I tried this approach with the negative Revenue already (I read it somewhere in another post). But it seems to do the trick just half way thru.
Tableau does not really connect the ending of the first bar with the beginning of the next bar and has overlapping values. This means also that my total is different as I have it calculated in the Excelsheet. It seems also that i have to use the data structure as in Sheet three since sheet 2 names the revenue 2012, 2013, 2014 and so on.
I attached the package workbook with the results so far.
Gant Waterfall.twbx.zip 18.0 KB
just for your information.
I finally contacted the Tableau support to help me on that. Danton was friendly enough to send me the solution. I was on the right track however missed an important part.
1.) Additional to the Table calculation (running Total) I had to choose advanced
2.) Then select from the available fields Year and then Product and move them to the right (compute using). The sequence is important here (Year must be top, followed by Product)
3.) Click OK twice and the result is exactly as I was expecting.
I tried that before but I always put either Year or Product on the selection but never both.
See also the attached Workbook for your reference.