We had a requirement where Master and Detailed report should be shown on the same report on click of the measure value as shown below.
In the Detailed report made the columns as 'is prompted' and kept the two reports in two different sections.
In the Detailed report section in the 'Edit Dashboard' gave the condition with reference of the Intermediate report and gave the condition as "equal to 1".So that the report is not visible at the initial view to the user. And save the page.
Now when the user clicks on the measure value then it navigates to the same page, but the values is passed to the detailed report as it contains 'is prompted'.
Hope this helps alot people out there.