[Sales] = FIXED [Sub-Category] : MAX([Sales]) Drag this Flag to the Color shelf. Filter to True .
Create the FIXED calculation.
You are experiencing the tension between and Aggregate Level calculations. fixed calculation tableau
You try a standard calculation: MIN(Order Date) . [Sales] = FIXED [Sub-Category] : MAX([Sales]) Drag this