Advanced table calculations

Before we move on to some practical examples, let's briefly consider advanced table calculations. Advanced, in this case, simply means that code is written instead of using a Quick Table Calculation option. You can see a list of available table calculation functions by creating a new calculation and selecting Table Calculation from the dropdown under Functions.

You can think of table calculations broken down into several categories. In each of the examples, we'll go to Compute using | Category, which means Department is the partition. The various advanced table calculations include:

• Meta-table functions: These are functions that give you information about the partitioning and addressing. These functions also include Index, First, Last, and Size.

  

  First gives the offset from the first row in the partition. So, the first row in each partition is 0. Last gives the offset to the last row in the partition. Size gives the size of the partition. Index, First, and Last...