Example of exclude level of detail calculations
Exclude level of detail calculations are useful when you want to perform certain calculations at higher (less detailed) levels than the view level of detail. The following example will demonstrate how we can leverage this functionality.
Average credit score per loan type
In this example, we’ll answer the following question: how does the average credit score for a given loan type compare to the overall average for the entire portfolio?
Take the following view, which shows the average credit score per loan type (where loan types are grouped into portfolios):
Figure 5.13: This crosstab shows the average credit score per loan type
What if we wanted to compare the average credit score of each loan type with the overall average credit score for the entire portfolio? We could accomplish this with an exclude level of detail calculation that looks like this:
{EXCLUDE [Loan Type] : AVG([Credit Score])}
