Matrix Report
A Matrix Report in Salesforce is a report format that summarizes data across two dimensions: row groupings and column groupings.
Definition
A Matrix Report in Salesforce is a report format that summarizes data across two dimensions: row groupings and column groupings. The result is a cross-tab grid where each cell shows the aggregated metric (sum, count, average) for the intersection of one row group and one column group. The classic use case is revenue by region by quarter: regions on rows, quarters on columns, opportunity amount in each cell. Matrix Reports answer two-dimensional analytical questions that tabular and summary reports cannot.
Salesforce supports four report formats: Tabular (a simple list), Summary (grouped by one dimension), Matrix (grouped by two dimensions), and Joined (combining multiple report blocks). Matrix is the most analytically powerful of the standard formats. The Lightning Report Builder provides drag-and-drop matrix configuration: pick the row grouping, the column grouping, the aggregation field, and the function. Charts on matrix reports use stacked bars, heat maps, or pivot-style visualizations to surface patterns the raw grid would hide.
How Matrix Reports model two-dimensional analytics
The four report formats
Salesforce reports come in four formats. Tabular: a simple flat list of records, like a spreadsheet. Summary: groups by one dimension with subtotals. Matrix: groups by two dimensions with row and column subtotals. Joined: combines multiple report blocks side-by-side. Pick the format based on the question; Matrix is for two-dimensional cross-tabs.
Row and column groupings
Matrix reports have two grouping dimensions. The Row Groupings appear down the left side of the report; the Column Groupings appear across the top. Each cell in the grid shows the aggregated metric for that row-column intersection. Both dimensions can have up to two levels of nesting (region/sub-region on rows, year/quarter on columns).
Aggregation functions
The cell value is computed by an aggregation function: SUM, COUNT, AVG, MIN, MAX. The aggregation runs over the records that match both the row and column grouping criteria. The most common pattern is SUM(Amount) on Opportunity, producing total revenue per cell.
Subtotals and grand totals
Matrix reports automatically include row subtotals (right edge), column subtotals (bottom edge), and the grand total (bottom-right corner). The subtotals make matrix reports useful for executive dashboards: a row total is the regional total, a column total is the quarterly total, the grand total is the everything-total.
Charts on matrix reports
Matrix reports support several chart types: stacked bars (group on row dimension, stack on column dimension), grouped bars (side-by-side bars per cell), heat maps (color-coded grid for visual scanning), donut and pie (for one dimension, the other summed). Picking the right chart matters; the grid alone is hard to scan.
Conditional highlighting and formatting
Matrix reports support conditional highlighting: cells above a threshold turn green, below turn red. The feature is configured per matrix; the highlighting surfaces patterns at a glance. Useful for performance reviews, capacity dashboards, and any cross-tab where outliers matter.
Performance considerations
Matrix reports query and aggregate at run time. Reports against high-volume objects (millions of records) can be slow; the aggregation runs over every matching row. Use filters aggressively to scope the report to the relevant data. For pre-computed snapshots, Reporting Snapshots or CRM Analytics datasets perform better at scale.
Build a Matrix Report in Lightning Report Builder
Matrix Report creation is a drag-and-drop task in the Report Builder. The work is picking the right groupings and the right aggregation.
- Open Report Builder
Click Reports tab, New Report. Pick the report type matching the source data (Opportunities with Account, Cases with Contacts, etc.).
- Switch to Matrix format
In the Report Builder, click Format dropdown, pick Matrix. The canvas changes to a cross-tab layout.
- Drag the row grouping
From the Fields panel, drag the field to use as Row Groupings (Region, Owner Role, Industry).
- Drag the column grouping
Drag the field for Column Groupings (Quarter, Month, Stage, Lead Source).
- Pick the aggregation field and function
Drag the metric field (Amount, Quantity) and pick the function (SUM, COUNT, AVG).
- Add filters and save
Restrict to relevant records with filters. Add a chart if useful. Save the report with a descriptive name.
Selects the source object and related-object joins.
The first dimension that appears down the side.
The second dimension that appears across the top.
The metric computed per cell.
Scope the report to relevant records.
- Matrix reports get slow on high-volume objects. Add aggressive filters; consider Reporting Snapshots or CRM Analytics for very large data sets.
- Two grouping dimensions are the limit per axis. Deeper nesting needs Joined Reports or analytics tools.
- Field-level security applies. Users see only fields they have access to; matrix cells with restricted fields render blank.
- Charts on matrix reports look different from charts on summary reports. Test the chart type against the data before committing.
Trust & references
Cross-checked against the following references.
- Matrix ReportsSalesforce Help
- Report Builder OverviewSalesforce Help
Straight from the source - Salesforce's reference material on Matrix Report.
- Reports OverviewSalesforce Help
Hands-on resources to go deeper on Matrix Report.
About the Author
Dipojjal Chakrabarti is a B2C Solution Architect with 29 Salesforce certifications and over 13 years in the Salesforce ecosystem. He runs salesforcedictionary.com to help admins, developers, architects, and cert/interview candidates sharpen their fundamentals. More about Dipojjal.
Test your knowledge
Q1. What is a Matrix Report?
Q2. When are Matrix Reports the right choice?
Q3. What are the four report formats?
Discussion
Loading discussion…