value result as a label

[EGilbert]

I have a table with a number of fields and 2 of them are

Manufacturer & Region

I would like the label of the expression to be shown as the manufacturer based on a specific region.

I tried the below formula:

=if([Region]='NA',Manufacturer,) 

Where 'NA' is a data response in the Region Field.  There are no duplicates in the Region field either.  I also tried the same formula as a separate expression with no bar and text on Axis selected.  The resulting label and result is blank.  Any ideas?

[petter · Accepted solution]

How about trying this:

=Concat( DISTINCT {<Region={NA}>} Manufacturer, ' / ')

[petter]

Please click the like button or heck if the response was correct you could even mark it as a correct solution.
Believe me - it will be greatly appriciated by the contributors ...
We love likes as much as anyone posting anything on social media

[EGilbert]

Worked great.  Thanks for the suggestion

[EGilbert]

Thanks again for the help.  I have added to my dataset and I now would like to show the OEM based still on region but with the highest Utilization in that region.  In the first table each region had 1 OEM/line of data.  I now have multiple OEMs per region and I would like to select the one with the highest amount in the 'Utilization' Field.  I tried using the same concat function and added the max formula I used to get the value in the bar graph but it did not work.  Any ideas on this one?