You try a standard calculation: MIN(Order Date) .

[Sales] = FIXED [Sub-Category] : MAX([Sales]) Drag this Flag to the Color shelf. Filter to True .

If you are in doubt, use FIXED . It gives you the most control because it does not try to guess what dimensions are in your view. The Silent Killer: Dimension Filters You must know one danger: Order of Operations .

If you have been using Tableau for more than a few weeks, you have probably hit the wall .

But LODs require you to think .

Imagine you have a dataset with 10,000 rows. A FIXED calculation runs once, creates a temporary lookup table (e.g., 100 unique customers), and then pastes that result back onto every relevant row.

FIXED [Sub-Category] : MAX([Sales]) Wait, that gives me a number, not a flag.