Level of detail calculations

Before getting into practical examples of using level of detail calculations, let's take a moment to understand the syntax and types of 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([Field])}

The definitions of the preceding declaration are as follows:

• FIXED, INCLUDE, and EXCLUDE are keywords that indicate the type of level of detail calculation. We'll consider the differences in detail in the following section.
• Dim 1, Dim 2 (and as many dimensions that are needed) is a comma-separated list of dimension fields that defines the level of detail at which the calculation will be performed.
• AGG is the aggregate function you wish to perform (such as SUM, AVG, MIN, and MAX).
• Field is the value that will be aggregated as specified by the aggregation you choose.

Level of detail types...