The simpler way is to drag Country to Rows shelf and the measure Number of Records to the Mark Text
Then click on menu Analysis and select the option Percent of > Table
This will convert the number of record in % of records per Country respect to total Number of Records.
There is other way, using a table calculation. In this case you need to create a calculated field, for instance Percent of records with the formula:
SUM([Number of Records]) / TOTAL(SUM([Number of Records]))
Create a new worksheet, drag Country to Rows shelf and the calculated field Percent of records to the mark Text. The values on percent of records are fractions of 1, so it is required to change the format of green pill on Mark text to Percentage. You are able to change this by clicking on green pill Percent of records, select Format and change Numbers to percentage.
See attached workbook as a demonstration. Note that I use States instead of Country in the workbook with sample data.
Example_RM.twbx 1.5 MB
Thank you Ramon - This is exactly what I wanted to know!
Thank you Prasanth - this is neat stuff!
I'm glad you get what you wanted to know
Could you please mark the thread as Question Answered?