When that calculation is placed on the row shelf, aggregated as AVERAGE and the dimension is placed on the column shelf, the view shows the average customer sales amount by region:
If the measure is dragged to the Rows shelf, the result illustrates the difference between the total sale for each region and the average sale per customer for each region:
Example 2
The following INCLUDE level of detail expression calculates the sum of sales by state:
{ INCLUDE : SUM(Sales)}
The calculation is placed on the row shelf and aggregated as an average. The resulting visualization averages the sum of sales by state across all categories.
When Segment is added to the Columns shelf and the calculation is moved to Label, the LOD expression results are updated. You can now see how the average sweden email list sum of sales by state varies across categories and segments.
EXCLUDE expressions
EXCLUDE level of detail declares dimensions that should be omitted from the view's level of detail.
EXCLUSION level of detail expressions are useful for “percent of total” or “difference from overall average” scenarios. They are comparable to features such as Totals and Reference Lines.
The EXCLUSION level of detail expression cannot be used in row-level expressions (where there are no dimensions to omit), but it can be used to modify a view-level calculation or anything in between (that is, you can use an EXCLUSION calculation to remove the dimension from some other level of detail expression).
Example 1
The following EXCLUDE level of detail expression calculates the average sales total by month and then excludes the month component: