This feature allows you to total how many times specific List dropdown items are selected within a form. It is useful when you want to summarise selections, track frequencies, or generate totals for reporting and analysis. This applies to Dashpivot Web templates and is designed for template editors using COUNTIF formulas to calculate totals.
Prerequisites
Before you begin make sure you have the following:
Plan: Standard (or higher)
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot, Basic excel formula skills
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open the template in Dashpivot Web.
Identify the List dropdown field or table column that contains the items you want to total.
Add a cell where you want the total for a specific dropdown option to appear.
Enter a COUNTIF formula to count how many times a specific option appears. For example:
=COUNTIF(B:B, "Excavator")
Repeat the formula for each dropdown option you want to total, replacing the criteria text as required. For example:
=COUNTIF(B:B, "No")
If referencing a specific table, use the table reference format. For example:
=COUNTIF(Table1!B:B, "Yes")
Save the template.