Not attached a workbook.
Like this? :
First create 3 calculations, one for each of the groups:
Create one for audi, bmw and vw.
Then add these all to text and allign it so that it is to the left:
Edit the label and make sure all the text options are in one row, then apply the text colour as desired:
Essentially, only the corresponding group will appear as a label.
Finally hide the group column:
Additionally, if you'd like group to be a label, then double click in columns to create an adhoc calculation and type in 'Group':
Then right click on the label and select format and allign the header to the left:
So then you get this:
Please see the attached workbook for more information.
cars status_v10.2.twbx 38.3 KB