I am pretty new with Tableau and I need your help for a visualization.
I have Col.1 = Country; Col.2 = Product name; Col. 3 = #Sales
I want to make a table that displays for each Country the Product name that has the maximum amount of sales.
Country | Product
AT | Shoes
where shoes are the product with max sales.
I had thought of a calculated field like this: if sum[Sales] = max([Sales]) then [Product Name] else Null END but it gives me an error.
Any idea of how to solve it?
Thanks in advance for any help given!