Switching the reports with the dashboard prompts
Hello Gurus
I have a report with Category, state, State Measure, National Measure and the requirement is
The user wants a bar graph with two state dashboard prompts with states and national in it so they can select state in one selector and national in the other one or national and state or national, national or state, state. Also here I am adding national to the state dashboard prompt manually by sql.
I need your advise how I will be able to switch between the reports I understand that I might need to create 4 different reports for the combinations but I would like to know how I should be able to do that and what is the logic.
Thanks
Ravi