This content has been marked as final. Show 5 replies
Yes your requirement can be done.
1) create a view selector for choosing either Table or Chart.
2) Then create column selector view to select which column you want.
We can archive this view selector.
Create two repots
1. table and revenue
2. chat and revenue
You have to add both reports to view selector view.
Thanks a lot for the reply,But i have 3 measure values on the report (and my 2nd drop down should be Revenue and Margin) EX
Weighted Revenue ,
Weighted Margin ,
Its not helping out when I'm having 3 measures each on the reports.
Any help please.
1) Create two report (chart & table based) then each view add one dummy column and make this to be prompted as (variable prompt)
2) Create Dashboard prompt --> create two variable prompt ( one for report selection and another one for measure selection (here u have to add measure column as value like Revenue,Margin...N etc)
then test it
For report as column selector via variable prompt option sample screen short
For report as prompt selection via variable prompt option sample screen short