FIXED level of detail expressions calculate a value using the specified dimensions, without reference to the dimensions of the view.
Example
The following FIXED level of detail expression calculates the sum of sales by region:
{FIXED : SUM()}
This level of detail expression, called , is placed in the text to show total sales by region.
The view's level of detail is more, but because FIXED level of detail expressions do not take into account the view's level of detail, the calculation only uses the dimension that is referenced in the calculation, which in this case is Region. Because of this, you can see that the values for individual states in each region are identical. For more information on why this happens, see Aggregation and Level of Detail Expressions.
If the INCLUDE keyword had been used in the level of detail expression instead of FIXED, the values would be different for each state, because Tableau would add sweden email list the dimension in the expression () to any additional dimensions in the view () when determining the values for the expression. The result would be as follows:
INCLUDE expressions
INCLUDE level of detail calculate values using the specified dimensions, in addition to any dimensions present in the view.
INCLUDE level of detail expressions can be useful when you want to calculate at a fine level of detail in the database and then re-aggregate and display at a coarser level of detail in your view. Fields based on INCLUDE level of detail expressions will change as you add or remove dimensions from the view.
Example 1
The following INCLUDE level of detail expression calculates total sales per customer: