Getting ready

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

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

How to do it...

How it works...

In the last recipe, we saw that creating drill-through link from 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 lines and order methods). 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 in 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 methods).

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

There's more...

You can use the Define content option also 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 differently define styles and conditional styling.