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