Level of Detail calculations
Level of Detail calculations (sometimes abbreviated as LoD calcs or LoD expressions) are a special kind of calculation that allow 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, orEXCLUDE), 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...
