It's difficult to troubleshoot which step you're missing. I've followed this tutorial on Youtube and was able to create the Sankey Diagram perfectly. Could you try this?
Thank you Gerardo and Shiva.
Gerardo - such an easy fix! I did not realize the ordering of the detail dimensions mattered. That solved my issue!