First question on this from me would be on the structure of the data. I have assumed that the sample Excel workbook that you have attached is reflective of the data that you hold and would like to report on. If this is not the case, you will need to tweak the calculations to ensure that you are able to draw the waterfall chart as required. At a very high level, there are many ways you can do this - Custom SQL is an option, and so is data blending... again, each option has its merits and demerits based on the structure of your data. I've written a blog on waterfall charts here - https://lovemydata.wordpress.com/2015/11/13/waterfall-charts/
For the current requirement, I have created a column on the Excel data that would differentiate between the A that forms a variance between 2013 and 2014, and the A that forms the variance between 2014 and 2015. With this new column, and using RUNNING_SUM and some conditional statements I am able to recreate the waterfall chart you required, as below:
I have attached the workbook for your reference. Let me know if this works...
Waterfall Chart Example.twbx 11.9 KB
I have made data into the below and please see to the attached sheet.
I did not get much time and I am lower version of Tableau. Hence I couldnt change the Label colors to match the mark color.
Please see to it. Hope this helps
Year Axis Size Values 2013 2013 124 124 2013 A 15.3 139.3 2013 B 8.6 147.9 2013 C 6 153.9 2013 D 3.3 157.2 2013 E -0.1 157.1 2013 F -6.5 150.6 2014 2014 151 150.6 2014 D 15.3 165.9 2014 A 14 179.9 2014 G 8.8 188.7 2014 C 7.4 196.1 2014 H 3.3 199.4 2014 B -3.4 196 2015 2015 196 196
WaterFall.twbx 8.7 KB
Thanks a lot for the guidance.
I was able to do the graph . But my issue was sorting . as in my original dashboard i have many steps so Manual sorting was not feasible.
But I used sorting method defined by Rasa Raza .
Thanks lot for helping me out here .
Thats Great Keerthana.
Please set this question to Answered