[OBIEE 11g] Multiple Values From Dashboard Prompts

Display report subtotal only if multiple values are selected from the dashboard prompt

 
To have a dashboard prompt on one column say Country. To show the subtotal if i select more than one country in the prompt otherwise the report should not have subtotal


Create a simple report - Label it as NoSubtotal.

Create one report - Subtotal - Here we are subtotal option has been enabled in the table view. 

Create one intermediate report - Prod Category Prompt report

Now we have to create a prompt on Product Category and give the reference of presentation variable A. 

Now let us go to the dashboard editor and make use of section condition and intermediate report.

Save the changes and test the dashboard.