Tableau LOD Expressions: FIXED, INCLUDE, EXCLUDE Explained with Examples

Tableau is widely known for its intuitive drag-and-drop dashboard interface. However, when building complex reports, analysts frequently need to compute values at multiple levels of granularity simultaneously. For instance, you might want to show individual customer sales while also displaying the total sales for their region on the same row. This is where **Level of Detail (LOD) expressions** are essential.

This guide explains the three types of Tableau LOD expressions, their syntax structures, and practical business dashboards cases.

1. LOD Expression Syntax

All LOD calculations follow a specific syntax enclosed within curly braces `{}`:

{ [TYPE] [Dimension1], [Dimension2] : [AGGREGATION]([Measure]) }

Where `[TYPE]` can be `FIXED`, `INCLUDE`, or `EXCLUDE`; followed by the dimensions you want to calculate at, a colon `:`, and the mathematical aggregation (like `SUM`, `AVG`, `MIN`, `MAX`) of the target measure.

2. FIXED LOD Expressions

A **FIXED** LOD expression computes values using only the specified dimensions, completely ignoring the dimensions present in the visualization view.

Business Use Case: Customer Cohort Sales
If you want to calculate the first purchase date for every customer (independent of date filters or product category segments in the report view):

{ FIXED [Customer ID] : MIN([Order Date]) }

This expression returns the absolute earliest order date for each customer, allowing you to track how cohort segments perform over time.

3. INCLUDE LOD Expressions

An **INCLUDE** LOD expression calculates values using the dimensions present in the report view **plus** the specified dimensions inside the calculation. This is useful when you want to compute at a lower level of granularity than what is shown in the chart.

Business Use Case: Average Sales per Customer by State
If your bar chart shows the sum of sales per State, but you want to calculate the average sales amount contributed by individual customers within each state, use:

{ INCLUDE [Customer ID] : SUM([Sales]) }

When placed in the report with the `AVG` aggregation, Tableau first sums the sales per customer within each state, and then averages those customer totals per state.

4. EXCLUDE LOD Expressions

An **EXCLUDE** LOD expression calculates values omitting the specified dimensions from the report's level of detail. It is the opposite of `INCLUDE`, calculating at a higher level of granularity.

Business Use Case: Regional Sales Contribution
If your chart shows sales per Segment (e.g. Consumer, Corporate) broken down by Region, and you want to calculate the total regional sales on every row to find the percentage contribution of each segment:

{ EXCLUDE [Segment] : SUM([Sales]) }

This calculation ignores the `Segment` dimension in the view, returning the total regional sales, which you can then divide the individual segment sales by to calculate the percentage share.