I need a report which shows Leads associated with in the last Quarter as well as the revenue the Campaign has generated in the last Quarter. I have been able to build to separate reports - one report showing the Leads created in last quarter and associated with the Campaign and the other report showing the Opportunities Closed in last quarter. However, I have been unable to create a single report or create a joined report combining them.

Is there a joined report possible here wherein I can combine the 2 reports based on Campaign Name?