Exclude Level of Detail. Similar to the 'Include' LoD expression, 'Exclude ' LoD expression is used when a particular dimension (s) are to be omitted from the level of calculation, out of the dimensions present in the view. EXCLUDE level of detail expressions are useful for 'percent of total' or 'difference from overall average ...
With the INCLUDE LOD calculations, you state the dimensions you need to aggregate your measures against in addition to the dimensions in the view. 3) Exclude LOD Calculation. With the EXCLUDE LOD calculation, you state the dimensions (included in the view) to exclude when aggregating your measures. A sample Tableau LOD expression is as follows: