How to show the maximum number of value of a column on the map chart
Hi,
I have data like below,
| Country | Type |
|---|---|
| India | GNS |
| India | GNS |
| India | SAS |
| India | SNS |
| Europe | SAS |
| Europe | SAS |
| Europe | SNS |
| North America | SNS |
I would like to show the maximum value by a country on the map. i mean, on India part, it should have GNS (Since it has max no of values), in europe it should show SAS (as SAS is maximum) and in North america is SNS (since only one)
.
I dragged the column country to the map . But i am stuck at how to show these values on the map base on the above condition. Your help is much appreciated.
Feb 1, 2019 2:45 AM
