---
schema_version: "1"
id: 23f14f8be103df4934def0332a3eb7b025dc1c3ffad58193a371d557b925640d
title: Count Unique Values in Report Results
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_count_unique_values.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_count_unique_values.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2ac824c5b54a1a627db92fc25b645b2f17e306044cf5d667dfa42c3c921b7917
description: See how many distinct values a column in your report returns with a unique count.
products:
  - Cross Cloud
release: "264"
---
# Count Unique Values in Report Results

See how many distinct values a column in your report returns with a unique count.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Essentials</strong>, <strong>Group</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d52586e82">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d52586e82 ">To add a unique count to a report saved in a private
              folder:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d52586e82 ">Create and Customize Reports</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d52586e82 ">To add a unique count to a report saved in a private or public
              folder:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d52586e82 ">Report Builder OR Report Builder (Lightning Experience)</td>

          </tr>
        </tbody>
      </table>

When you add a unique count to a column, it shows the number of unique column values in report results. Duplicate values aren’t counted.

1. While editing a report in the report builder, find the column for which you want to count unique values.
2. Click **![the more actions icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/resources-global/_corporate/images/dropdown.png)** | **Show Unique Count**.
3. Click **Save**.

A count of unique values appears as a grand total for the whole report and as a subtotal for each group.

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_example.png)

Example Opportunity reports often list multiple opportunities with the same account. Add a unique count to the Account Name column to see how many individual accounts values appear in the report.

![A unique count showing how many distinct accounts appear in report results](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/analytics/images/rd/rd_reports_unique_count.png)

To remove the unique count, click **![the more actions icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/resources-global/_corporate/images/dropdown.png)** | **Hide Unique Count**.

As you get ready to count unique values in report results, take note of these limitations.

- Each report supports up to three unique counts.
- Lightning table dashboard widgets don’t support unique counts.
- Null values, displayed as a dash (-), are counted as a unique value.
- Fields of these data types don't support unique counts:
    - Blobs
    - Clobs
    - Encrypted fields
    - Multi-select picklist
    - Text area, including long text area and rich text area