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.