Create the Source Report

This example has three parts: creating the target report, creating the source report, and defining the drill behavior.

Procedure

  1. Create a new report.
  2. In the New dialog box, click Chart and click OK.
  3. In the Chart group pane, click Column.
  4. In the Chart type pane, click Column.
  5. Click OK.
  6. From the Source tab source tab, expand Sales and Marketing (query) and then Sales (query).
  7. Expand Sales fact and drag Revenue to the Measure (Y-axis) drop zone.
  8. Expand Order method and drag Order method to the Series drop zone.
  9. Expand Product and drag Product Line to the Categories (X-axis) drop zone.
Parent topic: Example - Creating Drill-through Access in a Legacy Chart