Summary
In this chapter, we explored the inner workings of table calculations. We began by considering two questions:
- What is the function?
- How is the function applied?
As we explored these two questions, we surveyed each unique group of table calculation functions with the exception of the Script_ functions, which will be covered in more detail in Chapter 15, Programming Tool Integration. We also 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 counted, for example, the scope as Ship Mode, and the order of counting was Category and Region. Therefore, we would start with the first Category and Region and set 1 for the Ship Mode. We would then continue with the next Region in that same Category and count 2 for the next Ship Mode and so on. The order of how dimensions are being addressed is important...
