Does anyone know how to group several categories under specific regions, from highest to lowest, per region. Please see my attached chart for a better understanding of what I am trying to accomplish.

chart example.jpg

Thank you.