Result: Tableau looks at all chairs, finds the single highest sales number, and highlights only that row. Do not try to memorize every LOD syntax. Instead, memorize this question:
Create the FIXED calculation.
FIXED [Sub-Category] : MAX([Sales]) Wait, that gives me a number, not a flag. fixed calculation tableau
But LODs require you to think .