Agile BI - Excel users are fond of the Grouping features. Multidimensional cubes like SSAS and Essbase can manage Hierarchies, balanced and unbalanced.
Take 2 minutes to discover how to manage hierarchical data with Strategy Hierarchical Reporting Features. These features are in preview / Early Adopter for now, available since v10.4
Note: the Waterfall chart has been developped by Professionnal Services organization using D3. You can get in touch with them if you need to build custom charts like this one, using D3, HiChart, amCharts or Google Chart.