Explain Summary Report?

A Summary Report groups rows by one or more fields and shows subtotals for each group. It’s the most common dashboard source because the groupings drive the chart’s categories. Anything you’d want to see as “by stage”, “by owner”, “by region”, “by month” is a Summary report.

What it looks like

Stage: Prospecting
   Acme Corp Opp           $25,000
   Globex Opp              $40,000
   --- Subtotal:           $65,000

Stage: Negotiation
   Initech Opp             $80,000
   Umbrella Opp            $120,000
   --- Subtotal:           $200,000

Stage: Closed Won
   Stark Opp               $300,000
   --- Subtotal:           $300,000

Grand Total:               $565,000

The groupings — here, Stage — are the dimensions. The metric — here, Amount — is the measure.

Building one

1. Start a new report on a Report Type
2. Add filters and columns
3. Drag a field to the Groups → Group Rows pane
4. Add up to 3 levels of row grouping (e.g. Region → Industry → Stage)
5. Drag a numeric field to Columns → Summarize to control which aggregates show (Sum, Avg, Max, Min)
6. Run, save

Why Summary is the dashboard workhorse

• Charts read groupings as categories (x-axis) and metrics as values (y-axis)
• Subtotal logic produces clean drill-downs
• Up to 3 levels of grouping gives enough analytical depth for most KPIs
• Supports bucket fields for ad-hoc categorisation
• Supports summary formulas that calculate at the group level

Grouping levels

Region (Group 1)
   └── Industry (Group 2)
         └── Owner (Group 3)

Subtotals appear at each group level plus the grand total. Three is the max for Summary; if you need a fourth dimension, switch to Matrix (row × column) or Joined.

Summary formulas

Unique to Summary (and Matrix), summary formulas calculate at the group level:

Win Rate = RowCount[CLOSED WON] / RowCount[CLOSED]

These render as new columns at each group’s subtotal row — useful for ratios that only make sense at aggregate level.

Dashboards source

Summary reports power most dashboard component types:

• Bar / Column / Line / Donut → top-level grouping = categories
• Funnel → ordered groupings (sales stages)
• Metric / Gauge → grand total or one subtotal
• Lightning Table → the grouped rows themselves

Strengths and limits

Common follow-ups

• Max groupings? — 3 row groupings in a Summary report.
• Difference from Matrix? — Summary groups rows only; Matrix groups rows and columns.
• Difference from Tabular? — Tabular has no grouping.

Verified against: Salesforce Help — Group Report Data. Last reviewed 2026-05-17 for Spring ‘26.