
1. Re: Calculate Percentages from Sum Total
Arshiya Duseja Jun 3, 2016 2:59 PM (in response to Chitrarekha Saha)Do u wish to calculate Number of men/total number of people and number of women/total number of people?
Or is there something else?

2. Re: Calculate Percentages from Sum Total
Ivan Young Jun 3, 2016 3:05 PM (in response to Chitrarekha Saha)Hi Chitrarekha,
A simple formula like SUM([Female Count])/SUM([Total]) will give you the percent of females. I'm sure you can create one for males as well. Once you have done that drag your measures to tooltip.
Good luck,
Ivan 
3. Re: Calculate Percentages from Sum Total
Arshiya Duseja Jun 3, 2016 3:08 PM (in response to Chitrarekha Saha)Go ahead take a look

Gender Race Count per County.twbx 190.4 KB


4. Re: Calculate Percentages from Sum Total
Chitrarekha Saha Jun 4, 2016 9:06 PM (in response to Arshiya Duseja)Hi Arshiya,
Can you please send me just the workbook? Since I am still at version 9.2 I could not open the packaged workbook.

5. Re: Calculate Percentages from Sum Total
Arshiya Duseja Jun 5, 2016 11:04 PM (in response to Chitrarekha Saha)I am using 9.2.3.. No matter what I upload, you won't be able to open it. I
used the same formula Ivan wrote. Please try it else it's a free upgrade to
9.2.3
Thanks
Arshiya
On Jun 4, 2016 21:07, "Chitrarekha Saha" <tableaucommunity@tableau.com>

6. Re: Calculate Percentages from Sum Total
Chitrarekha Saha Jun 5, 2016 7:08 AM (in response to Chitrarekha Saha)I got it thank you!