FIXED [Category] : SUM([Sales]) → Category total. Then create: SUM([Sales]) / [Category Total] . Now, even if you filter to East region, the denominator stays the Category total across all regions. 2. Cohort Analysis (Customer’s First Purchase Date) Problem: You want to tag each transaction with the customer’s first order date to analyze retention by cohort.

Enter the .

FIXED is the most powerful—and often misunderstood—calculation in Tableau. Unlike its cousins (INCLUDE and EXCLUDE), FIXED operates of your worksheet’s filters and dimensions. It says, “Compute this value at this specific level, and I don’t care what else is on the view.”