Hi,
I have the following table:
I would like that when the column "Sub-category" has one manufacturer, the column "Manufacturer" should show the manufacturer name; but if it has more than one manufacturer, the column should appear in blank.
It should appear like in the table below:
How can I achieve this?
Please find attached the tableau file.
Thank you so much!
2 respostas
Hi Bordera
Sorry if my English is bad.
Create the following calculated field and replace it with Manufacturer.
IF {FIXED[Sub-Category]:COUNTD([Manufacturer])} > 1 THEN ''
ELSE [Manufacturer]
END
Thank you.
