Hi, so I have created calculated fields for two dimensions, first is age group with Millennials being the ages 18-35, Gen X being 36-51, Baby Boomers being 52-70 and WWII being 71 and above, the other calculated field are wealth segments with Mass Affluent (Net worth is between $100,000 and $1,000,000), Millionaire ($1,000,000 to $5,000,000) and UHNW ($5,000,000 to $25,000,000). I am able to create a table with the age groups across the vertical axis and wealth segments across the horizontal axis, I now, however, want to fill in the table with the percentage of those who are, for example, Mass Affluent and Millennials? How do I do this? When I fill in the text with Net Worth (Sum) it takes the sum of the total net worth for the entire pane, but each individual person has a different net worth, is there a way to calculate then the percentage of respondents that fit into the categories?
Can you please attach a Tableau Packaged Workbook with an example? It's hard to follow exactly what you're looking at without being able to see it.