1 Reply Latest reply on Jun 23, 2016 3:08 PM by Tom W

    Creating a graph with percentages of Two Dimensions

    Eric McDonald

      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?