Defining drill-through from crosstab intersection
We have a crosstab report that shows sales quantity by month and order method. We need to create drill-through links from months and sales values.
Getting ready
Create two target reports for the drill-throughs. One should take only Month as parameter. The other should take Month and Order method type. These reports will be referred to as Drill-1 and Drill-2 reports respectively.
Create a simple crosstab report to be used as main report. Pull Time/Month on rows, Order method / Order method type on columns, and Sales fact / Quantity as the measure.
How to do it...
In this recipe, you will see how to create a drill-through from a crosstab intersection to another report. To do this:
Select the Month item placed on crosstab rows. Click on the drill-through definition button from the toolbar.
This opens the drill-through definitions dialog. Create a new definition. Select Drill-1 as Target Report. Map the month parameter with the Month data item as shown...
