Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (47.2k points)

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.

E.g.

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!

1 Answer

0 votes
by (17.6k points)
  • You need a FIXED LOD to find the MAX(Sales) within Col1 and then output the level within Col2 matching with this MAX(Sales), extending  to your method 

IF ([Sales])== ({FIXED [Cat1]:MAX([Sales])}) THEN [Cat2] ELSE NULL END

  • Then add a Calculated Field to the Filter and filter out the NULL's.

enter image description here

Intellipaat offers Tableau Course training for the learners to master advanced visualization tools.

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.2k users

Browse Categories

...