This guide explains how to calculate a column total at the bottom of a Prefilled Table in Dashpivot Web using the SUM() formula. This is useful when you want to automatically total quantities, costs, hours, or other numeric values within a fixed-row table.
Video Walkthrough
Prerequisites
Before you begin make sure you have the following:
Plan: Standard, Pro, Premium, or Platinum
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot, Excel formula knowledge
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Navigate to the cell where you want the total to appear.
Make sure it's a formula field type.
Enter the cells that you need to add. Each table cell is labeled using a column letter and a row number, such as
A1,A2, etc.Calculate the column total in two ways:
Option 1: Add the cells directly. In the bottom of the prefilled table for example if it's A5, you add the following formula.
=A1+A2+A3+A4
Option 2: If you’re totaling a sequence of cells, use the SUM formula. Make sure to include in the formula the start of the range and the end of the range. In A5 you enter:
=SUM(A1:A4)
Where A1 = the first cell in the range, A4 = the last cell in the range.
All cells between A1 and A4 will automatically be included in the total.
TIP:
Avoid referencing the total cell in your own formula. For example, if your total is in A5, and you include A5 in the formula, the system will show an orange Circular dependency error because the formula is referring back to itself.
Make sure to specify the last row number in your range.
Using an open range like: =A:A on a prefilled table will also result in a circular dependency error, since it tries to include the total cell in the calculation.