Level of Detail Expressions (LoD) in Tableau: FIXED

The last keyword of LoD I am talking to is FIXED.

Remember!

By the function INCLUDE we included some numbers into the calculation even though we don't visualize this number.

By the function EXCLUDE we exclude some numbers from the calculation even though we visualize them.

With the function FIXED we “freeze” some numbers in our calculation, i.e. we can run calculation of all art, but the “fixed” dimension remains unchanged.

This is the structure of FIXED function:

With this function we can e.g calculate a frequency of customer's orders, calculate unique customers from month to month as the cumulative value etc..

Let us have a look to an example, where we analyze sub-categories:

I created a simple cross table with the data from Superstore:

I would like to see this numbers in a hint text, if I analyze sub-categories.

I created a stucked bar chart, which shows sales in each region. I also highlighted sub-categories with different color, as I would like to analyze them.

And now I would like to have a hint text, which shows me the sum of Sales per Region. I created a calculation's field:

{ FIXED [Region]: SUM([Sales])}

And put it on the “QuickInfo”