Tableau isn't made for duplicating excel's functionality. The only way to add that Pct column and Percent row will be to create them in separate worksheets and drag all three worksheets onto a dashboard where you can arrange them to look like that - like they're a single worksheet.
If you attach a sample workbook I can help you work through doing this.
Thanks for your quick response. I'm truly disappointed to understand that there isn't a magic approach that I had missed.
I also appreciate the offer to show me how to build a the desired dashboard chart as three components. I wanted to be a little more proactive so before I sent a workbook to work on, I thought I would try out an approach on my own. Here is what I came up with and would appreciate you comments relative to the approach being correct or where it could be refined.
Central Table is Crosstab with ROW/Column Grand Totals added
Built the row percentages by Percent of Total Table (column down) Calc applied to CNT(Model ID). I removed the left header information.
The row percentages were similar except for using row across for the table calculation. Removing the header got me the chart shown below:
My real question I brought these together, for right now, in a test dashboard but it looks like below. Though what I have found is that bringing these together, especially the column percent, take a lot of finesse relative to positioning and labeling.
Looks good. That's exactly what I meant when I said to build them separately and bring them together in a dashboard. Unfortunately it does require a lot of finesse to make it look like a single table, but that's the only way to do it in Tableau.