5 Replies Latest reply on Nov 9, 2016 8:16 AM by Norbert Maijoor

How to convert a column to a percentage and use the percentage in a calculated field?

Hi all,

I have created a table that includes the count of sales by district, with the sum of the population in each district. In a new sheet, I have converted all of the values to percentages (%) by right-clicking, Quick Table Calculation and then Percent of total for both of the measures/columns. Does anyone know how I can create a calculated field that allows me to divide the central column (% of total count...) by the column on the right (% of total population...)? I need to divide the PERCENTAGE NUMBERS and not the count numbers.

Thanks

Jag

• 1. Re: How to convert a column to a percentage and use the percentage in a calculated field?

Hi Jagdeep,

Find my approach as reference below and stored in attached workbook version 9.3 1 of 1 people found this helpful
• 2. Re: How to convert a column to a percentage and use the percentage in a calculated field?

Hi Norbert

Thanks for your reply. I can't seem to find the attached workbook?

Thanks

Jag

• 3. Re: How to convert a column to a percentage and use the percentage in a calculated field?

You need to go to original page.

You cannot see the attached file thru mail box view.

Thanks,

Shin

• 4. Re: How to convert a column to a percentage and use the percentage in a calculated field?

Hi Norbert,

When trying to access your file, I keep getting a message telling me that the file doesn't exist in tableau public, which I'm using.  Can you make the file available for tableau public?

Thanks

Jag

• 5. Re: How to convert a column to a percentage and use the percentage in a calculated field?

Jagdeep,

I stored the workbook at Tableau Public.