This content has been marked as final.
Show 5 replies
-
1. Re: How to show the maximum number of value of a column on the map chart
Zhouyi ZhangFeb 1, 2019 2:45 AM (in response to Dhivya Narayanasamy)
-
Book1_v10.2.twbx 38.5 KB
-
-
2. Re: How to show the maximum number of value of a column on the map chart
Dhivya Narayanasamy Feb 2, 2019 7:21 PM (in response to Zhouyi Zhang)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
David Maning Feb 2, 2019 12:47 AM (in response to Dhivya Narayanasamy)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
-
4Dhiviya.twb 217.6 KB
-
-
4. Re: How to show the maximum number of value of a column on the map chart
Dhivya Narayanasamy Feb 2, 2019 10:39 PM (in response to David Maning)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
Dhivya Narayanasamy Feb 3, 2019 12:25 AM (in response to David Maning)its not working either. can you provide me the formula using my data which i have given?