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.