In your sales organization, you want to know how business is doing this month. You'd like to know metrics such as opportunities created, deals closed, and deals closing next month. While in the past you had to create three separate reports in Salesforce, now, you can get all this data in one report by using the joined report format.
Here’s how to get the data with a joined report:
Example: Create a joined report with multiple views
Let’s start with a basic opportunities report and change it to the joined format.
Now what if you wanted to report on data from not one but several report types -- multiple objects in other words? Joined report is still the way to go. Take the following example.
Example: Combine data in a joined report from multiple report types
As a salesperson, you want to gauge the health of your accounts while prepping for customer calls. You'll need a report that looks at different opportunity and case records for each account. We'll pull in data from three objects.
To begin, create an accounts report. Then, add data from the Opportunities report type and Cases report type. You're able to add data for Opportunities and Cases objects because they’re related to Accounts, which is a common parent object. See how each report type that you add is its own block.
We'll create four blocks, each showing a different facet of the account.
There’s more you can do with joined reporting. For example, you can create summary formulas to calculate additional totals on number fields for one report type or create cross-block formulas to get totals for number fields across different report types.
To recap: Joined reports let you report across multiple data sets in a single report. See related data from multiple report types, or see different views of data from the same report type. Joined reports are available to you in Enterprise, Unlimited, and Developer editions.