There is a basic drill down feature in the Lead Management reports (https://community.marketo.com/MarketoArticle?id=kA050000000KypT&src=comm), but the use case you've described is better addressed with an Opportunity Analysis report in Revenue Explorer, which is available with the Select edition or Revenue Cycle Analytics (RCA).