---
schema_version: "1"
id: 7d089a78612da46d5d6d9d87f1885c6f8efe0fc0e8ace2db85554668ad3ea13e
title: Smart Totaling in Reports
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_smart_totaling.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_smart_totaling.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: fe166a9bf63efc2bd349eb731aae58d0589a6b7db5189b0ca12d8d2955153743
description: Smart totaling means that duplicate data is counted only once in a subtotal or total. Salesforce uses smart totaling when you run reports that include duplicate data in any column chosen for summing or averaging. Smart totaling is also available in dashboard widgets.
products:
  - Cross Cloud
release: "264"
---
# Smart Totaling in Reports

Smart totaling means that duplicate data is counted only once in a subtotal or total. Salesforce uses smart totaling when you run reports that include duplicate data in any column chosen for summing or averaging. Smart totaling is also available in dashboard widgets.

For example, an opportunity has two products, and you run the Opportunity Product Report with the total opportunity amount selected as a column to sum by. The amount appears twice in the details of the report, once for each product on the opportunity.

In this case, smart totaling correctly calculates any subtotals, grand totals, and averages, adding that opportunity amount only once.

#### See Also

- [Subtotal Report Results in Salesforce Classic](https://help.salesforce.com/s/articleView?id=analytics.reports_subtotal.htm&release=264.0.0&type=5 "Subtotaling your reports gives you a tool to analyze trends in the data. You can group sets of information, sort the groupings, and compare subtotals for each set against the overall total. In summary and joined reports, you can also subtotal by multiple fields to give you cascading sets of information.")