Answer the following questions to test your knowledge of the information in this chapter.
Q: If I'm not using any dimension filters, is there a difference between using a Percent of Total table calculation and using FIXED/EXCLUDE calculations?
A: While they will, in general, yield the same results, there a few exceptions that we have discussed in this chapter, and the main reason for the differences is the order of operations. FIXED calculations will remain unchanged by dimension and measure filters, EXCLUDE calculations will remain unchanged by measure filters (but not by dimension filters), and table calculations will be affected by both dimension and measure filters.
Q: Do LOD calculations have to use fields that are already included in the view? Can LOD calculations aggregate at a different level than the one determined by the fields chosen in the view?
A:...
