- Drag a Table object.
- Add the text, Europe Rank, as the object title.
- Add a dimension: Country.
- Uncheck the Include null values property.
- Add a new measure with the following expression, with the Regional Rank label:
= Max( Aggr(rank(Sum( {<Region={'Europe'}>} Sales)), Country))
- Add the second measure with the following expression, with the Global Rank label:
= Max( {<Region={'Europe'}>} Aggr(rank(Sum(Sales)), Country))
- Open the add-on section and uncheck Include Zero Values:
The result will look like the following screenshot: