Rollup

Rollup

Sample simple Organization structure:

  • 5 Departments (company departments), each department has a team name & associated team code
  • 5 employees working at different Departments
  • Vertical has many Employees : relationship has been defined

LookUp

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 vertical using "ROLLUP" columns

Adding a rollup column

1. Add new column

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

1

2. Feed column name

2

3. Select Column type as 'Rollup'

3

4. Choose Child Table

Table Employee in our example

4

5. Choose on ​Child column

Pick appropriate column for aggreagation

5

6. Select ​Aggregate function

Aggregate function will be "count" in our case

6

7. Click on Save

7

8. Column TeamCount is populated with appropriate information

8