# Nested LOD expressions and LOD aggregation

*Tableau Consultant Study Guide · Design and Troubleshoot Calculations and Workbooks · Last updated November 3, 2026 · https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/nested-lod-expressions-and-lod-aggregation*

Choose between FIXED, INCLUDE, EXCLUDE and table-scoped expressions, nest one LOD inside another, write dimension declarations that match the fields in the view, and predict whether an LOD result is aggregated or replicated when it meets the view's level of detail.

- Certification: Salesforce Tableau Consultant
- Exam section: Design and Troubleshoot Calculations and Workbooks
- Study guide: https://www.certifyforce.com/study-guide/tableau-consultant

**Official exam objective:**

> Implement advanced LODs, such as nested LODs.

## What the exam expects

- Pick FIXED, INCLUDE, EXCLUDE or a table-scoped expression from whether the result must ignore or follow the view.
- Build nested LOD expressions in which an outer expression aggregates the results of an inner one, with the right dimensions in each declaration.
- Use a FIXED expression as a dimension for cohort and histogram views, and know which LOD types can never be dimensions.
- Write dimension declarations, including date expressions, that match the fields on the shelves, and create quick FIXED fields from the Data pane.
- Predict what an LOD shows when it is finer than, coarser than or the same as the view, and what the pill's aggregation does in each case.

Key terms:
- **Dimension declaration:** the dimensions before the colon that set the expression's scope.
- **Aggregate expression:** the aggregated calculation after the colon; it may contain other LOD expressions.
- **Nested LOD expression:** an LOD expression inside another LOD expression's aggregate expression.
- **Replication:** a coarser LOD value appearing in several marks of a finer view.
- **Table-scoped LOD:** an expression with no keyword and no declaration, scoped to the whole table.

## Key facts

| Fact | Detail | Source |
|---|---|---|
| FIXED and view filters | Ignores all except context, data source and extract filters | [Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm) |
| INCLUDE and EXCLUDE vs filters | Considered after dimension filters | [How Level of Detail Expressions Work in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm) |
| Nesting | The aggregate expression can contain other LOD expressions | [Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm) |
| INCLUDE, EXCLUDE result type | Always measures | [How Level of Detail Expressions Work in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm) |
| EXCLUDE in row-level expressions | Not allowed; no dimensions to omit | [EXCLUDE Level of Detail Expressions](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_exclude.htm) |
| Quick LOD | Control-click drag a measure onto a dimension; creates FIXED | [Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm) |
| Typed vs dragged date pill | Typed YEAR() doesn't match; dragged becomes DATEPART('year', ...) | [Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm) |
| Table-scoped | Same as FIXED with no dimension declaration | [Table-Scoped Level of Detail Expressions](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_tablescoped.htm) |

## Check yourself

- Why does changing an EXCLUDE pill from ATTR to SUM leave the view unchanged?
- When can an EXCLUDE expression not be used at all?
- Why does a state filter change an INCLUDE result but leave a FIXED one untouched?

## Sources

- [Create Level of Detail Expressions in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm)
- [How Level of Detail Expressions Work in Tableau](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_overview.htm)
- [FIXED Level of Detail Expressions](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_fixed.htm)
- [EXCLUDE Level of Detail Expressions](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_exclude.htm)
- [Table-Scoped Level of Detail Expressions](https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_tablescoped.htm)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 7 linked practice questions, and unlimited timed mock exams are included with the Tableau Consultant pack (USD $19): https://www.certifyforce.com/practice-exams