Please find here the post describing the method I used to build this decision tree with almost no data preparation :
Have fun !
Dear Zach Pipkin, @Jeffrey Shaffer, @Bill Lyons, and @Olivier Catherin,
I apologize for leaving this post hanging for so long. Life took over and I was away from Tableau for a while. I'm back now and I was extremely excited to see the solutions (and suggestions) that you guys came up with from my original question. Thank you all for your insights and I can't wait to apply this approach to some new data.
Sankey diagram looks really great. Suppose when I select Project 3 under Project, curves with green color are showing to Budget Centers 1,6,7,8. What I am trying is Only Budget centers 1,6,7,8 should be highlighted with green color(as the curve is green) and remaining Budget centers are shaded out when I select Project 3. same thing with Budget Center. When I select Budget Center 1, Projects 3,4,5, should be highlighted with Blue color(as the curve is Blue) and remaining Projects are shaded out. Is this possible in tableau.
I would like to understand how the proportion of projects assigned to budget center is determined in the data. Like 50,25,25 etc.