Answer the following questions to test your knowledge of the information in this chapter.
Q: Is it true that table calculations take into account the underlying data and can help create weighted averages?
A: No, table calculations use the results of prior aggregations as input for new ones, so a table calculation for an average will do a straight average of the results within the scope, not a weighted average. For an example, please refer to the first section of this chapter.
Q: One of the options for quick table calculations is Total Sum of all values. True or False?
A: False. The different options are listed in the chapter, although you could use one of the manual Window functions to achieve this result.
Q: Table calculations can also be created on dimensions. True or False?
A: True. You can create table calculations on counts and distinct counts of dimensions.
...