How to make a crosstab intersection drill through to different reports

Check list of all posts

Please see the following screenshot, where crosstab intersection can be drilled through to three different reports, quantity report from quantity measure, revenue report from revenue measure, and planed revenue report from planed revenue measure


This sample is used to demonstrate conditional a concept to go different drill through report from crosstab intersection. Please download report specification for review in detail.



Create a crosstab report


Define drill though for Quantity to Quantity report
Highlight intersection for revenue

Change define Contents as “Yes”

Drag query item revenue to intersection

Highlight revenue and define second drill through with revenue report

Repeat the same process for planned revenue for planned revenue report