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.

In this recipe, you will see how to create a drill-through from a crosstab intersection to another report. To do this:

You will notice that when we created the drill-through from row titles (Month), we didn't have to unlock the items. Whereas, for the intersection, we had to unlock them.

Now try one thing. Lock the report objects again and select the crosstab intersection. Try to create drill-through now. You will see that the drill-through definition button is disabled.

For some unknown reason, Report Studio doesn't allow you to create drill-through from crosstab intersection. You need to select the Fact cells class or the Text item within the intersection. By unlocking the object, we select the text item within the intersection and create a link from there.

Another way is to right-click on the intersection and to choose Select Fact cells. This will enable the drill-through button and let you define one.