How to do it…

  1. Once the data is loaded, open the App overview window and create a new sheet.
  2. Enter the Edit sheet mode on the sheet.
  3. Create a Table object.
  4. Add Country as the dimension.
  5. Next, add the following measure and label it No of Customers:
Sum([No of Customers]) 
  1. Under Appearance, open General and, in Title, add the following expression:
=Max(aggr(Sum([No of Customers]), Country)) 
  1. Next, in Subtitle, add the following expression:
=Firstsortedvalue(Country, -aggr(Sum([No of Customers]), Country)) 

The resulting table will look like this:

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

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