
1. Re: Calculating Percentages on a Bin
Ashish Chaudhari Jun 6, 2016 11:20 PM (in response to Joseph Chung)Sample data will be appreciated on which we can take this further.

2. Re: Calculating Percentages on a Bin
Joseph Chung Jun 7, 2016 10:18 AM (in response to Ashish Chaudhari)For example, I have the following 5 age groups: 'Under 5', 510', '1015', '1520', 'Over 20'. Each of these bins have a specific number of records. I want to add 2 age groups  'Under 5' and '510'  and see what percentage of the total these two make up. So for the 'Under 5' category, there are 14 records, and for 510 there are 22 records, making a total of 36 records in the two bins. There are a total of 49 records in the data set among all 5 age groups. I want a calculation on Tableau that does this sum (14 + 36), and then will give me the percentage for 36/49 (73.37%). Hope this helps!

3. Re: Calculating Percentages on a Bin
Ashish Chaudhari Jun 7, 2016 10:18 PM (in response to Joseph Chung)Will it be a static? I mean this age grps which you have mentioned as a Numerator will be fixed? (Under 5 and 510) Also it will be helpful if you can draw the output the way you want or simple % value will do the job?
Let me know about this.