DrillThrough Pages

Here we are going to set up a Drillthrough using some report pages that have already been created.

  1. Open the folder location you downloaded the files to.

  2. Go to Lab File > then Select Lab 3 Drill Through.pbit

  3. Open the page Customer Details. This report contains a list of customers who have made orders. Drill Through Details

  4. In the fields pane make sure Keep all filters is toggled on. Drag the field StateProvinceName into the field that says Add drill through fields here Drill Through Overview

  5. Ensure Used as category is selected. Check California Drill Through California

  6. Your report should look like this.

Notice a back button has appeared in the top left Drill Through Report

  1. Go back to Page 1

  2. Insert a Blank button onto the page

  3. Under button Options toggle on Action and set the following

  4. Type: Drill through

  5. Destination: Customer Details Drill Through Button

  6. Turn on button text and change to Click for more detail You may have to resize the button Notice the button is greyed out Drill Through

  7. Select a state on the bar chart Notice the button is now active. Hold down CTRL and click the button

  8. Notice it has taken you to the Customer Details Page and passed through the StateProvinceName you clicked on.