Good Morning James,
It'd be most helpful if you could post (attach) a sample workbook showing more detail and the work you've done thus far.
That said, if you have what you want and simply want to show % of total rather than total N, then simply use the Quick Table Calculation "Percent of Total".
Here's a handy little blog post that walks you through it: Quick Table Calcs: How to Calculate Percent of Total in Tableau - The Data School
If you find this post helpful or answers your question please mark it as such so that others can find it quickly.
Tableau Online Deployment Advisor
Thanks for the response. I have attached an example workbook here.
I understand what you are saying with the percent of total. However, for example, I am looking to show the percent of females that fall in the 25-29 age groups of the total workforce population. When I use the percent of total feature, I am only getting the percent of females that fall in the 25-29 age groups of the total female workforce population.
On the first sheet, I have essentially what I would like. I did this by creating a calculation of the n in that subgroup divided by the static number of the total population of the entire workforce. As you can imagine, I would like to be to have this 'static number' not be static, but instead be dynamic so I could run filters on it such as hourly/salary. Then --> the percentage of females that fall into the 25-29 age groups would change with my filters as the both the numerator and denominator would change.
Does this make sense? Is it possible?
Thanks again for the help!
Thanks for the clarification. Unfortunately, I don't think the attachment made it. I'm not seeing it, could you please retry?
It won't let me add it in this reply. However, if you go to the original post, are you sure it is not available there? If not, I will try something else.