see the attached
couple of things going on here -
Tableau will do all the totally for you so don't include the region or industry totals in the data
second you need to pivot the data Pivot Data from Columns to Rows
so the data looks like this
then percent of total is a table calculation see Table Calculation Functions
or in heat map form
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Tableau sample_v10.2.twbx 53.9 KB
Hi Jim - just what I needed! Thanks!