Recruiter screen - Mentioned it will be a storytelling technical round Team member - 30mins interview on Tableau (he was very helpful and altered his questions to help me get the answer). Another round of advanced Tableau Final round with the VP of the team

Finding top N within nested categories

If you have the following Category | Sub-Category | Sales for Sub-Category | How do you calculate the total sales for each category

Sub question - What are the different types of LOD

If you have Category (Columns), Sub-Category (Rows), and Sales in the Text card; how do you highlight the min and max sales for each category with red and green color? The rest of the sales need to stay blue/ default color.

Formula debugging Will this calculation work? IF [Category Name] = 'Cardio Equipment' THEN SUM([Sales]) ELSE null END