Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
How about trying this:
=Concat( DISTINCT {<Region={NA}>} Manufacturer, ' / ')
How about trying this:
=Concat( DISTINCT {<Region={NA}>} Manufacturer, ' / ')
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 |
Worked great. Thanks for the suggestion
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?