I have reattached your workbook. Create a duplicate of Region. Then, create a set with the Duplicate of Region and Firm. Place this set on the rows shelf between Region and Firm; and sort it based on sum of Sales.
Then, place Sales on the columns shelf. Right click on it and add the Percent of Total.
Hope this helps!
Hi Tracy, why the duplicate? Looks to work the same with the original. Am I missing something?
Timothy, just in case you didn't know, you can hide that set by unchecking "Show Header".