Drilldown via Double-Click
In some cases, you can drill down by double-clicking a row (other than a total row).
In some of these cases, the system uses the hierarchy, if any, to determine how to drill down. In other cases, the system drills down in a custom manner, as defined in the pivot table.
Drilldown in a Hierarchy
This section describes drilldown in a hierarchy. For example, in the Patients sample, The ZIP code level is the parent of the city level. Consider the following pivot table:
If you double-click the cell 38928, the system displays the following in the upper right of the pivot builder area:
And the pivot table looks like this:
Custom Double-Click Drilldown
To customize how the system drills down, see Customizing Double-Click Drilldown. This section provides a demonstration.
For example, consider the following pivot table:
Suppose that for this pivot table, we specify Drilldown Expression as follows:
colord.h1.[favorite color].members
gend.h1.gender.members
If we double-click the cell 32006, the pivot table then looks like this:
If we double-click the cell None, the pivot table then looks like this:
If we double-click again, nothing further happens.
Saving the Drilldown
If you drill down in a pivot table and then save it, the Analyzer saves its drilldown state. That is, when you next open it, the Analyzer redisplays the pivot table with the drilldown. Similarly, if the pivot table is included in any dashboards, they display it in its drilldown state.
Clearing the Drilldown
To clear the drilldown of a pivot table, you can do any of the following:
-
Click the left arrow button in the toolbar.
-
Click the X button in the Drill down area in the toolbar, if applicable.
-
Click the << arrows in any of the rows in the pivot table.