Table visual - group by

Have you tried setting this as a Matrix instead of a table?

Note:  I've turned 'Stepped Layout' off (under Row Headers).  I've not applied most of the stuff in your post, but they are all available.  You should be able to simply select your existing table, click on "Matrix" and then ensure your Region and Location columns are under the "Rows".  You can turn all the totals off as well.