Not sure to get exactly how your thing work. Report 2 and 3 always display data of a single customer, the one you click on report 1?
If that's the case you better use master-detail instead of navigation.
Master-detail will only change report 2 & 3 (both details) by selecting the customer you click on report 1 (master).
Thanks for the reply.
Sure, I will try 'Master- Detail' and let you know.
Just FYI.... these three reports are from same subject area but different tables (Of course there is common dimension Customer Available.)
Just to add that...
These 3 reports are Independently designed and attached to a dashboard... this means: Three reports are from different analysis with different tables and Views.
Different reports, different columns ...
Master-detail to not care as long as the column "driving" the logic (customer) is the same one, and it's your case !
Master-detail is often used inside the same analysis to drive different views, but can always perfectly works between different analysis in the same dashboard page.
So there is no reason why it wouldn't be what you look for: it does exactly what you described.
you can also use hidden dashboard prompts to 'catch' the drill down on specific values in your report and set presentation variables, which you then use as the basis of filters in the target, using this technique you can get around drill limitations, it no longer has to be based on the same subject area content.
Hope this helps,
Master-Detail is working fine, as individual report.... A report with multiple views.
But if I use multiple master-detail reports in the same dashboard with a common column --- Currently this is not working.
I am still working through this, will let u know, if this is successful.
Thanks for your inputs @Robert Angel & Gianni Ceresa