1> Create a dimension hierarchy. Even if the tables are different they can be part of same logical table. Like Country and State can be from different tables but you add these 2 tables in LTS and create hierarchy.
2> Create a summary report and a Detail report. Provide action link from summary to detail report.
3> Use Master detail link between summary and Detail report. You will have to keep Master and Detail reports in same dashboard.