You didn't mention the version of the workbook (it's not 9.3), so I'm not posting the workbook. But here are the three calcs:
IF [Countycode] = 'mana' THEN '
' + '
STR( [County] ) END
IF [Countycode] = 'Masu' THEN ' ' + STR( [County] ) + '
' + '
IF [Countycode] <> 'Masu'
AND [Countycode] <> 'mana' THEN [County] END
Put all three on the Label shelf and you'll get this:
2016-03-28_13-22-16.mp4 299.9 KB
Sorry, it's 9.2.1. That's not exactly what I get, but with a few tweaks I should be able to get them all where I want them to be. Thanks!
Yeah, it's a bit tweaky doing it this way, but it does beat placing them individually. I was a bit surprised at how the carriage returns work. I didn't think I would have to list each one separately. But Happy you worked it out.
I guess I haven't. Each time I add a new calculated field to the map to control the placement of one specific label it moves all the others (generally up a bit). From the default locations I'd like to move "Middlesex" and "Suffolk" to the right, "Plymouth" to the left, and "Nantucket" down.
No matter what combination of calculated fields I use something ends up off. I had everything in place except I couldn't move "Plymouth" left, so I tried to move it down. I added one '+' at a time to the calculated field and it slowly inched down. And then adding one more '+' and "Dukes" just disappears.
And then there is the order of the fields when added to the Marks box. The labels of counties move around and/or disappear just by changing the order.
I'm going to leave it like this, as perfecting it is way too frustrating and requires much more effort than it should. Thanks again for getting me on the right track.
PI2.twbx 79.8 KB