first create your subquery report. If the subject area does not exist do it by direct database request. Save the report by name 'xyz'.
Later create main report by the same way and filter the column of the main query by "is based on results from another analysis". Now whenever you will run this main report , it will be filtered based on your sub query report.
(Please mark this answer, if you find helpful)
Thanks a lot.Could you please let me know How can i place main report into dashboard without sub report.
Note:My both report,have the prompt values.Once i select prompt values then only my sub report it will return values.Based on subreport then main report it will work.
But i dont want to display subreport into my dashboard.
Could you pls let me know How can i achive this.
After setting the filter based on another analysis(sub query report) save the report and place in the dashboard in the same way as other reports.
create new section under the main report and pull the sub query report and in the section properties under CSS type Display: None. so that this report wont display in the dashboard but what ever the values you select in the prompt will reflect in the sub query report based on that the main report will reflect.
Note: Don't forget to set protect filter for sub query report.
Mark if Helpful/correct.