create a calculated column for country, add logic :
IF [RNK] > 9 THEN 'Others'
ELSE [COUNTRY] END
hope that helps,
thanks for your help. I have already tried your approach but when I create
the calculated column I get an error:
Any other ideas?
| facebook <https://www.facebook.com/MarineTraffic> | google+
<https://plus.google.com/+marinetraffic> | twitter
On Mon, Mar 6, 2017 at 5:26 AM, sunil.sachdeva <email@example.com
image.png 16.3 KB
Find my approach
Create a set on country for top 10
then create a calculated field
If set1 then [Country] else 'others' end
it will work as you wants
I have had similar requirement a couple of months back, refer the attached packaged workbook(last modified in 10.2 version).
Hope this Helps!!
Top N City+Others.twbx 1.2 MB
Many thanks Nipun, it worked.
Thank you Dhruv, I followed the "sets" approach mentioned above and it worked. I will take a look at your approach as well.