Sankey Chart and Hierarchical Data

Hello everyone,

This is my first time posting here, however I has already provided with a lot of help.   I'm hoping that you can help me figure this one out.  I'm trying to build a Sankey chart to incorporate hierarchical data but have not been able to so far.

My data set looks like this:

Parallel to this, I have the three tables explaining the meaning of each of the target and end points. Such as:

To build the Sanskey chart, this works fine.  The problem comes when I try to filter the results based on one of the values.  If I filter the values on the tables, the tables will show correctly the results, for example, filtering for B100, will show me in the table of Os the O101 and O102, and in the table of Cs the C101, C102, etc.

However, the Sanskey chart will only show the connection between Bs and Os, not showing where the flow continues to.  

When I filter in the Sanskey chart, by selecting one of the Middle Nodes, it will show me the full path, however when I select the starting node it will filter the diagram to only show from Start to Mid point (B to O) but no C connections but the tables show all the values that are supposed to.  Additionally, if I try to select the C nodes, nothing will show in the tables.

Any help would be appreciated.