Salesforce Lightning Reporting and Dashboards

Hands-on exercise for creating a Joined report

Let's consider a use case: showing all won opportunities and cases related to the accounts in one report for the last year. Remember that, as of the Summer '17 release, the Joined report is available only in Classic, so you need to do the following in the Classic user interface only:

1. Navigate to the Reports tab and click on the New Report... button.
2. Select the Opportunities report type; it is under the Opportunities category.
3. Click on the Create button to continue.
4. Change the Show field to All opportunities.
5. Change Date Field to Close Date and Range to Previous CY.
6. Click on the Remove All Columns link, click on OK to confirm, and then add these fields to the report: Opportunity Name, Account ...