## 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**...