Using Month() on the Columns shelf, a view is created that shows the difference between actual sales per month over a four-year period and the average monthly sales for the entire four-year period:
Example 2
The following level of detail expression excludes from a sum of calculation:
{EXCLUDE : SUM()}
The expression is saved as .
To illustrate how this expression might be useful, first consider the following view, which breaks down the sum of sales by region and by month:
Remove color shades from the view to sweden email list show total sales by month, but without the regional component:
Table scoped
It is possible to define a detail level expression at the table level without using any of the scope keywords. For example, the following expression returns the minimum (earliest) order date for the entire table:
{MIN()}
This is equivalent to a FIXED level of detail expression with no dimension declaration:
{FIXED : MIN()}
LOD Expression Syntax
Level of Detail Expression Syntax
A level of detail expression has the following structure: