Switching between two Reports using Prompts and Guided Navigation

For this we need
one prompt to select the reports.
two reports for navigating into respective report.
two more reports for intermediate use in the guided navigation to pass the presentation variable.

1.Create a dashboard prompt as that should able to select values of different reports.
Like 1 value for 1 report and 2nd value for 2nd report.
And give the query in show option

SELECT CASE WHEN 1=0 THEN "D2 Market"."M01 Market" else 'Revenue' END FROM "Sample Sales"
union all
SELECT CASE WHEN 1=0 THEN "Products"."Product" else 'customers' end from "Sample Sales Reduced"

and give presentation variable ,here im taking it as var_p


By doing like above we can see the dashboard as

2.Now select the required fields into criteria tab
Report for prompt value customers

similarly create one more report for prompt value Revenue for revenue report
3.Now Create the two intermediate reports for above two reports to pass the presentation variable.
Like


give the filter as '@{var_p}'='Revenue' in Advanced -->Convert this filter to SQL
as well as in second intermediate report give the filter as '@{var_p}'='customers'

4.Now create a dashboard with 3 sections.
Section1: drag the prompt
section 2: drag the 1 st report and give the guided navigation as intermediate report_1 path.
section3: drag 2nd report and give guided navigation as intermediate report_2 path


5.save the dashboard you will see the windows for each value in the prompt like
For Revenue it fetches the revenue_sum_r report

and for customers it fetches #customers_r report

If you select the All choices,nothing will be displayed since it passes the null values to the reports.