Tableau — Hard In Tableau, what is the purpose of the EXCLUDE LOD when used to compute a percent of total? A EXCLUDE forces the total to be computed at the row level of the data source B EXCLUDE removes null values before computing the total C EXCLUDE is not suitable for percent-of-total calculations; FIXED should always be used instead D EXCLUDE removes the category dimension from the LOD so the total is computed at a higher level, enabling correct percent-of-total calculations even as filters change the view Show explanation
