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). If the field is already an aggregate calculation, you will not specify an additional aggregate function.
• Field...