Skip to main content
All CollectionsSupport GuideDashpivot - WebFormulas Functions
How to average a column of a default table using another table (cross-referencing)
How to average a column of a default table using another table (cross-referencing)

Learn how to calculate for the average of a column in a default table and display the answer in another table

Janmari Tanga-An avatar
Written by Janmari Tanga-An
Updated over 6 months ago

Default tables allow you to continuously add rows when you fill out the form, therefore there isn't a fixed number of rows when the template is created. This doesn't allow you to have a row for the average at the bottom of the same table. The only way to do it is to create a second table for the average and cross-reference it to the first table.

To start, navigate your cursor to the left tab and choose the 'Default table' under 'Table'. Input your data.

Next, add a 'Prefilled' table under that and set one cell as your display cell.

To average a column in a default table, use the formula to the display cell:

=AVERAGE(Source_Table!Column:Column)
  • Where Number1 is the start of the range, and Number2 is the end of the range.

  • Average calculation includes Number1, Number2, and the numbers in between.

For example:

Given that

  • Table1 is the Source_Table

  • A is the Column

  • Table2 cell B1 is your display cell

Use the formula to Table 2 Cell B1,

=AVERAGE(Table1!A:A)

Did this answer your question?