Rollup

Rollup

Sample Organization structure:

  • 5 Departments, each department has a team name & associated team code
  • 5 employees working at different Departments
  • Teams has many Employees : relationship has been defined

Screenshot 2022-09-09 at 12 57 32 PM

RollUp AGGREGATION functions supported

  • Count
  • Minimum
  • Maximum
  • Average
  • Sum
  • Count Distinct
  • Sum Distinct
  • Average Distinct

Now, we can explore how to extract employee count information per team using "ROLLUP" columns

Adding a rollup column

1. Add new column

Click on '+' icon to the left of column headers in Departments table

2. Feed column name

3. Select Column type as 'Rollup'

4. Choose Child Table

Table Employee in our example

5. Choose on ​Child column

Pick appropriate column for aggreagation

6. Select ​Aggregate function

Aggregate function will be "count" in our case

7. Click on Save

Screenshot 2022-09-09 at 1 03 49 PM

Column Employee Count is populated with appropriate information

Screenshot 2022-09-09 at 1 07 45 PM