Skip to main content

Custom Double-Click Drilldown

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:

rows show data grouped by zip codes

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:

rows show data grouped by favorite colors of patients in ZIP code 32006

If we double-click the cell None, the pivot table then looks like this:

rows show data grouped by female and male patients, for patients with no favorite color in ZIP 32006

If we double-click again, nothing further happens.

FeedbackOpens in a new tab