Please try like this..
Please apply the is Prompted filter in both the main and drill down report for date column.And you can set the is prompted Filter for Filter based on another analysis report as well for that date column.
Please mark if it works...
If analysis are coming from different Subject Areas but your "Table Name"."Column Name" is the same then the "Is prompted" option should work.
With "Dim Date"."Month" and "Dim Dealer"."Dealer Name" from "Subject Area 1" you should be able to filter "Dim Date"."Month" and "Dim Dealer"."Dealer Name" of "Subject Area 2"
If Table and column names don't match, try with PortalPagenNav where you can precisely set which column you want to filter and the value to apply.
Thanks for the response .
Sorry for the confusion actually we have 2 prompts dealer and month and its day wise daily report when we are clicking on the date column data in the drill down report it is showing whole month detail data it as to show only that particular date details report.
How we have to apply that particular date into the detail report as a filter to show the report for particular date data and we are having same generic date column in in both of the reports.
i think explanation is clear please suggest
Thanks in advance
Can any one suggest on this.
Thanks in Advance,