Tableau LOD Expressions Guide: FIXED, INCLUDE & EXCLUDE

If you have ever tried SUM([Sales]) / SUM([Sales]) and got 100% on every row, you hit the grain problem. Tableau LOD lets you declare the denominator's grain explicitly — from Total to Category — without moving pills. Built from scripts 08–09 on Superstore, this is the conceptual moat between basic and analyst-level Tableau.

For calculation basics see Tableau Calculated Fields and for table-scoped logic see Tableau Table Calculations. For modelling see Tableau Relationships vs Joins.

What is an LOD Expression?

Grain control in curly braces Tableau Help: LOD Overview. Think camera lens: the visualisation is the current zoom, LOD lets you compute at a different zoom.

{ [Type] [Dimension] : AGG([Measure]) }
 
// Examples
{ FIXED [Category] : SUM([Sales]) }
{ INCLUDE [Product Name] : AVG([Sales]) }
{ EXCLUDE [Region] : SUM([Sales]) }

Every LOD is wrapped in {}. Inside: the keyword, optional dimension list, colon, then aggregation. The result is aggregated and can be used anywhere a measure is used.

How does FIXED work and when to use it?

Locks to declared dimensions, independent of view Tableau Help: FIXED.

// Category sales regardless of view
{ FIXED [Category] : SUM([Sales]) }
 
// Category + Region grain
{ FIXED [Category], [Region] : SUM([Sales]) }
 
// First order date per customer for cohort
{ FIXED [Customer Name] : MIN([Order Date]) }

Key property: FIXED evaluates before most Dimension Filters in Tableau Order of Operations — between Context Filters and Dimension Filters. Use it when:

• You show Sub-Category but need Category totals per row.
• You compute Percent of Total where denominator must stay full total despite Sub-Category filters.

If your view shows Sub-Category and you filter out 'Chairs', {FIXED [Category] : SUM([Sales])} still returns Furniture's full total — allowing correct percent.

When should you use INCLUDE vs EXCLUDE?

Both respect view filters and viz LOD Tableau Help: INCLUDE/EXCLUDE — opposite of FIXED.

• INCLUDE: adds a dimension missing from the view.

// Average per Product when view shows only Category
{ INCLUDE [Product Name] : AVG([Sales]) }

Tableau computes AVG at Product Name grain then aggregates to the Category view. Without INCLUDE, AVG would be at Category grain — a different number.

• EXCLUDE: removes a dimension present in the view.

// Category total despite Region being on Rows
{ EXCLUDE [Region] : SUM([Sales]) }

View shows Category × Region, but EXCLUDE yields one Category total repeated across regions — revealing broader trend vs regional split.

How do you build Percent of Total?

Ratio of two aggregated grains Tableau Help: LOD. The error Cannot mix aggregate and non-aggregate appears when one side is row-level and the other is LOD-aggregated. Fix by aggregating both:

// Overall percent
SUM([Sales]) / SUM({ FIXED : SUM([Sales]) })
 
// Category-level percent
SUM([Sales]) / SUM({ FIXED [Category] : SUM([Sales]) })
 
// Format as percentage in Format pane

Nesting LODs solves complex cases: SUM({INCLUDE [Product Name] : SUM([Sales])}) / SUM({FIXED : SUM([Sales])}) — numerator at product grain, denominator at total.

Always test with filtered vs unfiltered view: FIXED denominators should hold steady.

Pitfalls and quick reference

Check Tableau Help: LOD for source compatibility (some OLAP cubes restrict LOD). Explore our Complete Tableau Guide and Tableau Tips for Analyst Workflows, or apply LODs to time analysis in Tableau Table Calculations and interactivity via Tableau Parameters.