Pivot Drill Through to Details

Overview

Pivot and Chart views provide the capability to drill through to details. What we mean by drill-through to details, is that Explore Analytics can show you a list of the record that make up the item that you selected. In a Pivot, you can drill through to details on a cell (numeric value), on a row, or on a column.

Drill Through

To drill through, click on the cell, row, or column and select the desired option from the pop-up menu.

Let's explain these three options using our example.

Cell

The value of 30,400.00 is the payments for "Double Bed" for "2009". Drill-through to details will show us the list of all the payments for Double Bed for 2009. These should add up to 30,400.00. This gives you an excellent way of verifying the value and understanding what it includes.

Row

In our example, drilling through on the row means that we want to see all the sales for "Double Bed".

Column

Similarly, drilling through on the columns means that we want to see all the sales for "2009".

Returning to the Pivot

When we drill through, we see the list and the breadcrumbs at the top of the view indicate that we're on the "Details". To go back to the pivot, you can click on the previous breadcrumb that has the name of the view ("Yearly Product Sales" in our example). Alternatively, you can click the browser back button.

Selecting the Fields to Show in the Drill Through List

The drill through list--the list that is displayed when you drill through--is made by copying the current view, switching it to a list, and adding filter conditions to select the drill through rows. Therefore, you can control the list of fields for the list by editing the list portion of your Pivot View. To do that, temporarily change you view to a list by clicking the List button that's directly above the view title. Don't worry, your Pivot will be preserved. In the View mode, you can select the fields, order them, set sorting, and even add hyperlinks. See List for more details about working with lists. When you're done, switch your view back to a Pivot by using the Pivot button next to the List button.

Drill Through in Published Views

Drill through in a published view is possible if the published view is "live", if the user is logged on, and if drill through was not disallowed.