EXCLUDE LOD calculations

While INCLUDE LOD calculations enabled us to calculate along the view dimensions and the further dimensions specified, EXCLUDE LOD calculations enable users to make calculations omitting one of the dimensions that have been used in the view. For instance, we can use EXCLUDE to calculate the total sum of profits for one category across regions, even if Region is used as a row. This is especially useful when dealing with contributions to a total.

Example 1 – contribution to total

Using the Global Superstore dataset, we want to show contributions to total profit for the South region of the EU market, slicing by country, category, and subcategory. What is the contribution of the Fasteners subcategory...