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

Learn how to sum a column from a default and display the result 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 totals or sums at the bottom of the same table. The only way to do it is to create a second table for the totals 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.

Use the formula SUM() to your display cell:

=SUM(Source_Table!Column:Column)

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,

=SUM(Table1!A:A)

Did this answer your question?