Fixed Calculation Tableau Here

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

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 calculation tableau