Level of Detail calculations

Level of Detail calculations (sometimes abbreviated as LoD calcs or LoD expressions) is a special kind of calculation that allows you to perform aggregations at a specified level of detail, which may be different from the level of detail defined in the view, and then work with the resulting value at a row level. In this way, you can think of LoD calculations as a hybrid between Row Level calculations and Aggregate Row Level calculations.

Level of Detail syntax

Level of Detail calculations follow this basic pattern of syntax:

{[TYPE] [Dimension 1],[Dimension 2] : AGG([Measure])} 

The parts of the preceding declaration are as follows:

• TYPE: Is the type of LoD calculation (FIXED, INCLUDE, or EXCLUDE), which are described in detail in the following section.
• Dimension 1, Dimension 2: Is a comma-separated list of dimension fields that define the level of detail at which the calculation will be performed. You may use any number of dimensions to define the level of detail...