Create a new drill-through target that accepts Month and Product line as parameters. We will call it Drill-3 from now on.

For the main report, we will use the same crosstab report as in the previous recipe.

In the previous recipe, we saw how to create a drill-through from a crosstab intersection to another report. In this recipe, we want to make it more complex. The drill-through line should be different based on the crosstab column. To complete this recipe perform the following steps:

In the last recipe, we saw that creating drill-through link from a crosstab intersection needs that we unlock the item and create it from the text item within.

In the case of a discontinuous report, we have different items on columns (Product line and Order method type). However, when you select the text item from intersection, Report Studio doesn't distinguish between them.

Hence, we need to select the intersection under one of the column items and set its Define content to Yes. This means we want to override the contents of this intersection and define the contents ourselves.

After changing the property, Report Studio makes that intersection empty. We can then unlock the items and drag any measure/calculation into it. We chose to drag Quantity again. Now Report Studio will distinguish between both the Quantity items (the one under Product line and the one under Order method types).

Finally, we defined drill-through to Drill-3 appropriately.

You can also use the Define content option to override the information being displayed. For example, if you want to show Revenue under Product lines instead of showing Quantity.

This also gives you the opportunity to define styles differently and use conditional styling.