Hello,
I have a dimensional report with 2 crosstabs. One crosstab is viewed (drilled) by region whereas the other crosstab is drilled by function. We show either regional data or functional data (based on input). The user wants the ability to toggle between region and function. By default, the user drills up/down on regions (first crosstab) and if he finds anything odd then he may need to see the functional data (second crosstab) for the drilled regional value (based on the drilldown value on the first crosstab). The parameter value is not getting updated when I drillup/down for me to resubmit the page. So, I had to create a drill through to the same report as target and pass the regional/functional values from the query as parameters to get the relevant drilled value. This is working one time but somehow it is not working second time. What is the best way to achieve this?
Interesting. What about creating a Master-Detail?