Here is a detailed breakdown of the feature, how it works, syntax, and practical use cases.
In Tableau, the is one of the most powerful features in the calculation language. It allows you to compute values at a specific level of granularity, independent of the dimensions currently used in the view. tableau fixed calculation
| LOD Type | Granularity Behavior | Use Case | | :--- | :--- | :--- | | | Specific: Uses only the dimensions listed in the formula. Ignores view dimensions. | Benchmarking, Ratios, Aggregates at a higher/lower level than the view. | | INCLUDE | Additive: Computes at the view level dimensions PLUS the dimensions listed in the formula. | "Show me the average sales per state, but include the customer level detail in that average." | | EXCLUDE | Subtractive: Computes at the view level dimensions MINUS the dimensions listed in the formula. | "Show me the total sales by Region and State, but exclude State so I can see the Regional total next to the State total." | Here is a detailed breakdown of the feature,
FIXED [Region] : SUM([Sales])