Hi,

It requires some steps.

1) Pivot data in data view to make a dimension 'Metric' and a measure 'Value'

2) Create rank calculation using different levels

3) Prepare 'measure filter' to filter the site

1) pivot data

create table  *remember to add 'country' in detail mark.

2) Edit rank

Rank country

Do the same for rank global

3) prepare measure filter

*measure filter is to be applied after the table calculation.  it is common to filter after rank calculation.

Best regards,

Hideki OGAWA

If you have Tableau version 2018.X versions, they have added a new feature of achieving what you want using " Pass Through Functions (RAWSQL)"

Pass-Through Functions (RAWSQL) - Tableau

Also, if you wan to see it in action, follow this questions :

https://community.tableau.com/ideas/4553    -- check Yuri's answer.

Sadly I have 10.5, so I would also implement the above solution. If you are stuck, try getting the ranks from a database system itself or follow this link:

Tableau Tip Tuesday: How to Filter a Dimension and Maintain the Rank

Hope it helps.

Only Excel, text data, pdf and google spread sheet are supported.  It is not a version specific now (v9 afterward, I guess).

For other data sources, custom SQL is available though I am not familiar with it.

Tableau Prep should support other data sources as well.

And yes it duplicates other measures if they are not included in the pivot.  Dividing by number of variables will be necessary.