I saw your question when I was reviewing Joe Mako's nifty answer to this question where he calculates %total for the sub totals:
Attached is a workbook that uses Joe's technique plus Jonathan Drummey's multiple crosstab / conditional formatting technique to get multiple string-based measures crosstab with %total subtotals. Each worksheet has a few notes I made for myself to remember this stuff. Let me know if the notes aren't clear. Or I can edit one of your workbooks. ...
subtotalPercentages.twbx.zip 226.0 KB