a) asking questions about RawSQL before you have explored the capabilities of Tableau's built-in hierarchies, grand totals & subtotals, table calculations, and level of detail expressions is putting the cart before the horse. In any case, you can write extremely complicated SQL expressions inside RAWSQL, however you have to use the Legacy (MS JET) connector to get access to RAWSQL.
b) The mockup you provided is trying to make Tableau behave like Excel or an old-school BI tool with lots of hierarchies and roll-ups. Tableau is designed more for interactive analysis with the data and trying to make Tableau behave like those other tools can be at times like putting a square peg into a round hole. My suggestion is to ask some questions such as "what are the business questions users are answering with this dashboard?" and "what is the next action users will take with what they learn from this dashboard?" and build to that. For example if the goal is to browse through to find the location with the most increase then build a view that shows that. You'll a) get a view that is easier to build in Tableau and b) have happier users.