How to do it…

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

The result will look like the following screenshot:

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset