Summary

In this chapter, we explored the inner workings of table calculations. We began by considering what the partition and direction of a table calculation are. In the thereafter following sections, we distinguished directional and non-directional addressing of table calculations, which eventually lead us to the Edit Table Calculation interface, and we identified it as the place to change partition and addressing (also called the scope and direction). As we explored, we surveyed each unique group of table calculation functions except for the Script_ and Model_ functions, which will be covered in more detail in Chapter 15, Integrating Programming Languages. We learned how to apply these functions to a view through partitioning and addressing, where partitioning can be seen as the scope and addressing as the direction of the calculation.

We have seen examples where we compared measures over different time periods, like weekly profit numbers, or comparing a part to the whole....