Table Calculation Application: Addressing and Partitioning

In the previous section, you learned about quick table calculations. But did you notice that all these calculations were working at the row level? What if you need to apply calculations at the column level? This is where the concept of addressing and partitioning comes into play.

Addressing means defining the direction of the calculation. A calculation can compute horizontally or vertically, depending on the option selected. Partitioning can be defined as the scope of the calculation; for example, you can partition a view into various years for different categories, or various categories for the same year.

In this section, you will learn about the following methods to address and partition data:

• Table(across)
• Table(down)
• Table(across then down)
• Table(down then across)
• Pane(down)
• Pane(across then down)
• Pane(down then across)
• Cell
• Specific Dimensions

You will continue...