Relative versus fixed
We'll look at the details shortly, but first it is important to understand that table calculations may be computed in one of the two following ways:
- Relative: The table calculation will be computed relative to the layout of the table. They might move across or down the table. Rearranging dimensions in a way that changes the table will change the table calculation results. As we'll see, the key for relative table calculations is scope and direction. When you set a table calculation to use a relative computation, it will continue to use the same relative scope and direction, even if you rearrange the view. (The term here is different from Relative To that appears in the UI for some quick table calculations.)
- Fixed: The table calculation will be computed using one or more dimensions. Rearranging those dimensions in the view will not change the computation of the table calculation. Here, the scope and direction remain fixed to one or more...
