Im trying to create a report with a table and chart views.
Can i have the report as below:
1.Need to have a drop down for only View ie) Table,Chart
2.Need to have another drop down with values ie) Revenue and margin
If i click on Table and then revenue it should show revenue table values
If i click on Chart and then revenue it should show chart with revenue values
Same with margin.
Can this be done.
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.
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