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 takes only Month as parameter. The other takes Month and Order Method (Henceforth referred to as Drill-1 and Drill-2 reports respectively).
Create a simple crosstab report to be used as main report. Pull Time dimension | Month on rows, Order method | Order method on columns, and Sales fact | Quantity as measure.
How to do it...
-
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.
-
Now click on the unlock button
from toolbar to unlock the items.
Select the text item from crosstab intersection. Hit the drill-through button again.
Create...
