Fixed Tableau Calculation |best| Jun 2026

FIXED [Region] : SUM([Sales]) / SUM(SUM([Sales]))

What’s your favorite use of FIXED? Have you run into any weird behavior with filters? Share in the comments!

Unlike standard table calculations or basic aggregations, fixed tableau calculation

Enter the .

| LOD Type | Relationship to View Dimensions | Example Use | | :--- | :--- | :--- | | | Ignores view dimensions. Uses only dimensions listed in the expression. | Computing a global benchmark or region-level total regardless of view drill-down. | | INCLUDE | Adds a dimension to the view. Calculates at the view level plus the dimension listed. | Useful when you want to compute a lower-level metric (like customer-level sales) but then aggregate it up (average sales per customer) in a higher-level view (like Region). | | EXCLUDE | Removes a dimension from the view. Calculates at the view level minus the dimension listed. | Useful for "difference from average" comparisons where you want to exclude the dimension you are currently viewing. | | Computing a global benchmark or region-level total

Separates the dimensions from the mathematical logic.

Suppose you have a dataset with a category dimension and a sales measure. You want to rank the categories by sales, while fixing the category dimension. fixed tableau calculation

Remember: Only FIXED gives you full control independent of the view.