Use the Advanced tab
in the Drill down dialog.
Steps:
1. In Report
Studio, create a simple list report based on the Great Outdoors Company
sample. 2. Drag the Product line level into the list.
3. Under Data -> Drill behavior, allow drill
down.
4. Open the created query and drag into it the level that you wish to skip to (for example, Product)
5. In the Drill behavior dialog, click the Advanced tab.
6. Select Change Expression in Drill-down behavior.
7. Select Product under Data item.
8. Run the report and drill down on Product line. The report will drill down to Products for this Product line, skipping over the intermediate level Product type.
4. Open the created query and drag into it the level that you wish to skip to (for example, Product)
5. In the Drill behavior dialog, click the Advanced tab.
6. Select Change Expression in Drill-down behavior.
7. Select Product under Data item.
8. Run the report and drill down on Product line. The report will drill down to Products for this Product line, skipping over the intermediate level Product type.
