How to make a conditional crosstab intersection drill through

Check list of all posts

Please see the following screenshot, where crosstab intersection can be drilled through only of the revenue value < 200,000,000


This sample is used to demonstrate conditional crosstab intersection drill through. The condition can be any condition that we can be defined. Therefore, this concept can resolve many different problems. Please download report specification for review in detail.


Create a crosstab

Highlight intersection text and then copy it as below

Define drill through for right one

Click left one and define conditional style, make text only show when revenue value >= 200,000,000 for not drill through items


Click right one and define conditional style, make text only show when revenue value < 200,000,000 for drill through items