Is there a way to pass the Crosstab Column data item from the Rows node member?
We have a cube based report that displays say Year on the columns, Product on the Rows and a Sales measure value. We would like to drill through to another report from both the measures and the rows. On clicking a row the drill through report needs to display Product, the years from the parent report and other measures.
The report also has drills enabled, so when users drill up to quarters and then click on a product row member the drill through report should bring up the product, all quarters displayed on the parent report.
Setting the Year data item as a Property on Crosstab row node member didn't help.
Any suggestions?