Default tables in Dashpivot Web allow users to add unlimited rows, but they do not support built-in totals. To calculate the total of a numeric column in a default table, you can use a second prefilled table with a formula that cross-references the default table column. This method enables dynamic totals that update automatically as new rows are added.
Prerequisites
Before you begin make sure you have the following:
Plan: FreeTrial, Standard, Pro, Premium, Platinum
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open the form template in edit mode.
Add a Default table to your template if one has not already been added.
Ensure the default table contains a numeric column with the values you want to sum.
Add a second table to the template and set it as a Prefilled table.
Click into the cell in the prefilled table where you want the total to appear.
Change the cell type to Formula.
Enter a SUM formula that references the numeric column in the default table. For example:
=SUM(Table1!B:B)Replace
Table1with the name of your default table andB:Bwith the column you want to sum.Press Enter to apply the formula.
Save the template.
Note
Default tables do not support totals directly, so totals must be calculated in a separate prefilled table.
The total will automatically update as new rows are added to the default table.