Fixed Calculation Tableau – Full & Validated

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

But what if you want the FIXED calculation to respect the year? fixed calculation tableau

Have you used FIXED to solve a tricky business problem? Share your example in the comments below. [Sales] = FIXED [Sub-Category] : MAX([Sales]) Drag this

But LODs require you to think .