Level of detail calculations (sometimes referred to as LOD calcs or LOD expressions) are a fourth type of calculation that allow you to perform aggregations at a specified level of detail, which may be different from the level of detail that was defined in the view. In many cases, you can then work with the resulting value at a row-level. In this way, you might think of LOD calculations as a hybrid between aggregate calculations and row-level calculations.
Level of detail calculations
Level of detail syntax
Level of detail calculations follow this basic pattern of syntax:
{FIXED|INCLUDE|EXCLUDE [Dim 1],[Dim 2] : AGG([Row-Level])}
Definitions of the preceding declaration are as follows:
- FIXED, or INCLUDE, or EXCLUDE, is a...
