In Tableau, the Exclude Level of Detail (LOD) function allows you to specify a level of detail that you want to exclude from your visualization.

This can be useful for a variety of reasons, such as removing outliers or creating a more focused view of your data.


One common use case for the Exclude LOD function is to create a more focused view of your data.

For example, suppose you have a dataset that includes sales data for multiple Sub-Category, and you want to create a visualization that compares and shows the differences in sales between selected subcategories from other subcategories

Let’s build it and see how it works


Step 1

Drag the Sub-Category to the Rows shelf and Sales to the Columns shelf



Step 2

Create a Sub-Category Parameter and show the parameter


Step 3

Create a calculation field for Selected Sub-Category


Step 4

Create a calculation field for Exclude Selected Sub-category using Exclude LOD function


Last step

Create a calculation field for the sales difference compared to the selected sub-category and other sub-categories.


We can now see the sales performances between the selected sub-category compared to other sub-categories

Overall, the Exclude LOD function can be a useful tool for creating more focused and accurate visualizations in Tableau, and it can be used in a variety of different scenarios to help you get a better understanding of your data.


The Data School
Author: The Data School