How Can I Combine Two Custom Reports into One Report in Salesforce

Last Modified: March 7, 2024 - 3 min read

Julian Alvarado

One common challenge many Salesforce users face is understanding how to merge or combine reports for a comprehensive overview.

Specifically, many ask, “how can I combine two custom reports into one report in Salesforce?” This guide will walk you through the process step by step, making it easy for users of all skill levels.

Understanding the Scope of Combining Reports in Salesforce

To begin, combining reports in Salesforce, more commonly referred to as creating ‘Joined Reports,’ allows you to view data from different objects side by side. It’s like opening two reports next to each other, whether they’re from one object or several.

This feature is incredibly useful for comparing data sets, like open and closed opportunities, without toggling between multiple reports.

Step-by-Step Guide to Creating a Joined Report in Salesforce

Start by searching for “Reports” in the Salesforce search bar. Navigate to the Reports section and select or open an existing report.

"Opening the report section in Salesforce to initiate a joined report".

Within your chosen report, look for and select the ‘Join Report’ option, then apply it. This action will transform your report into a ‘Joined Report’ format, indicating ‘Block 1’ on your report.

Selecting the join report option in Salesforce

Name this first block based on the filtered data you wish to analyze (e.g., “Opportunities Closed Won”).

Naming the first block in a joined report in Salesforce

Adding & Configuring the Second Block (1:09-1:44)

Add another block by selecting the ‘Add Block’ option and customize it — for instance, set it to show “Opportunities Open”.

Salesforce to Spreadsheets
Sync Live Salesforce Data into Your Spreadsheet

“Salesforce reporting is annoying and limiting. Coefficient allows us to report, analyze, and manipulate data with automated spreadsheet imports and writebacks. It’s saved me a crazy amount of time and allowed me to easily create live models in Sheets.” — Grant Guerrero, CS Strategy & Operations @ Qualified

Get Started Free
Adding and configuring the second block in the joined report

Upon completing the configurations, you will see the two blocks (e.g., “Closed Won” and “Open” opportunities) side by side.

This visualization aids in efficiently comparing different data sets within a single view.

Viewing combined Salesforce reports side by side

Best Practices

  • Saving and Sharing Reports: Once you’ve crafted your joined report, consider saving it in a shared folder accessible to your team. This practice fosters collaborative analysis and decision-making.
  • Clarity and Customization: Employ the Salesforce Report Builder to its full potential, customizing reports to align perfectly with user needs. Clear, well-structured reports significantly improve user engagement and comprehension.
  • Extending Capabilities: For scenarios where native Salesforce functionalities fall short in merging complexity, turning to external tools or Salesforce AppExchange solutions is advisable. This approach helps overcome limitations, offering more sophisticated merging capabilities.

Simplify Your Salesforce Reporting with Coefficient.

By following this guide, combining custom reports in Salesforce becomes a straightforward process, resulting in a cohesive view of related data sets.

Looking for an even more streamlined way to manage and analyze your Salesforce data? Check out Coefficient, a robust integration tool that connects Salesforce with platforms like Google Sheets and Excel.

Try it now for free!

Connect Salesforce to Spreadsheets Instantly

Sync Salesforce data or reports into Google Sheets or Excel with Coefficient's bi-directional connector.

Try the 2-Way Salesforce Spreadsheet Sync Trailblazers are Raving About

When did you last hit a blocker with native Salesforce reports? Find yourself manually exporting data to spreadsheets to make reports there? Or manually pushing data updates back to Salesforce?

Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading Salesforce spreadsheet automation tool trusted by over 350,000 professionals worldwide. Nix the manual labor and drive more flexible reporting in Google Sheets or Excel on your Salesforce data.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies