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: