5 Replies Latest reply on Feb 3, 2019 12:25 AM by Dhivya Narayanasamy

# How to show the maximum number of value of a column on the map chart

Hi,

I have data like below,

Country
Type
IndiaGNS
IndiaGNS
IndiaSAS
IndiaSNS
EuropeSAS
EuropeSAS
EuropeSNS
North AmericaSNS

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.

• ###### 1. Re: How to show the maximum number of value of a column on the map chart

Hi, Dhivya

Please find my solution attached, below is the screenshot of sample

Hope this helps

ZZ

• ###### 2. Re: How to show the maximum number of value of a column on the map chart

The above calculation is not working .I have a data like above with 100000 and it shows wrong value on the map

• ###### 3. Re: How to show the maximum number of value of a column on the map chart

Hi,

The solution is really simple. Here is its example.

IF

{ FIXED [State]:MAX({ FIXED [State], [Category]:IFNULL(SUM([Sales]),0)})}

=

{ FIXED [State]:MAX({ FIXED [State], [Category]:IFNULL(SUM([Sales]),0)})}

THEN [Category]

END

Please find the worksheet below. Trust this helps.

D

• ###### 4. Re: How to show the maximum number of value of a column on the map chart

hi David,

thank you for the workbook, Unfortunately its not opening. Do you which version of it?I have 10.5 and 2018.1. It's not opening in both of the version

• ###### 5. Re: How to show the maximum number of value of a column on the map chart

its not working either. can you provide me the formula using my data which i have given?