The percentage occurrence of the "dedicated" value for each business in each country.

[Anonymous]

Hi everyone!

I have a table with a column which shows two possible values ("Dedicated", "Non dedicated"), two another columns called "Origin country" and "Business" with many many rows. 

Now, I would like to create a new table which groups by country and business and show the percentage occurrence of the "dedicated" value for each business in each country.

[CoreyP]

This seems to work:

This is my sample dataset:

[Anonymous]

Thanks a lot CoreyP.

I've tried what you recommended to me but it doesn't work.

I created a tabla like this:

And I created a new column like this:

As you can see, the percentages are the same for every row.

[CoreyP · Accepted solution]

Oh, mine is a measure, not a column.