Skip to main content

How to Calculate the Percentage of Rows Meeting Multiple Criteria in a Table (Dashpivot Web)

Learn how to calculate the percentage of rows that meet multiple conditions and display the result in a summary table.

Adriana De Souza avatar
Written by Adriana De Souza
Updated this week

Calculating a percentage of fields with multiple criteria means solving for the number of times certain conditions are met divided by the total number of rows in the table. This formula works for both Default and Prefilled tables.

Prerequisites

Before you begin make sure you have the following:

  • Plan: All Plan Types

  • Permission: Home Folder (Template Library) – Org Controller (or higher); Team Folder – Project Controller (or higher)

  • Skills Required: Dashpivot

  • Device Type: computer

  • Subscription: Dashpivot

Step-by-Step Instructions

  1. Navigate to the left panel and choose either a Default or Prefilled table as your source table.

  2. Add a Prefilled table to act as your summary table.

  3. Change the display cell in the summary table to a Formula field.

  4. Enter the following formula:

=COUNTIFS(Source_Table!Column:Column, Criteria_1, Source_Table!Column:Column, Criteria_2, Source_Table!Column:Column, Criteria_n)/Number*100

Replace:

  • Source_Table with your data table name.

  • Column with the column being evaluated.

  • Criteria_1, Criteria_2, Criteria_n with the required conditions.

  • Number with the total number of rows in the table.

If the total number of rows is unknown, use:

=COUNTIFS(Source_Table!Column:Column, Criteria_1, Source_Table!Column:Column, Criteria_2, Source_Table!Column:Column, Criteria_n)/COUNTA(Source_Table!Column:Column)*100

Since a Default table does not have a fixed number of rows, COUNTA() is used to dynamically count the total rows.

Example

You want to calculate the percentage of employees who:

  • Worked 8 or more hours

  • AND have their License Renewed = Yes

Assume:

  • Table1 is your data table

  • Column F = Hours Worked

  • Column G = License Renewed (Yes/No)

  • There are 10 total rows

Formula (Known Total Rows)

=COUNTIFS(Table1!F:F, ">=8", Table1!G:G, "Yes")/10*100

Formula (Unknown Total Rows – Recommended for Default Tables)

=COUNTIFS(Table1!F:F, ">=8", Table1!G:G, "Yes")/COUNTA(Table1!A:A)*100

This:

  • Counts rows where Hours Worked ≥ 8

  • AND License Renewed = Yes

  • Then divides by the total number of populated rows

  • Multiplies by 100 to return a percentage

Related Articles
How to generate a Pass/Fail result at the bottom of a table based on a count on Dashpivot Web
How to Generate a Score from a Table on Dashpivot Web
How to Add Up the Number of Rows of a Default Table on Dashpivot Web
How to Calculate a Percentage Complete in a Dashpivot Table
How to Calculate a % Score Based on List Dropdown Selections in a Row on Dashpivot Web
Did this answer your question?