For Each state display the city name having highest sales.
Thanks Guru's,
Prazval.ks
Step 1:
Create 3 calculated fields
1.City Sales 2.Top City Sales 3.Top City Name by below formulas.
Step 2:
Double click on state geographic
dimension, select filled map in marks card shelf, drag and drop “Sales” measure on color, label of the marks card and drag
and drop “Top City Name” calculated field on label of the marks card.
Thanks Guru's,
Prazval.ks