Your eyes are probably glazing over just reading this.  A reader named John wrote to me with the scenario above, and my first thought was: They need a Sankey diagram.  Unless you are deep in the data ...