Can a Pivot drill down into another pivot

D

Dineshnewcommer

Hi,
I have a situation where I need a pivot dirll down to take the uses to
another pivot instead of the underlying data. can any one suggest how this
can be done.

Thanks
Dinesh
 
D

Debra Dalgleish

You could use the worksheet's Before_DoubleClick event to activate a
cell in the other pivot table. For example:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
Sheets("Data").Activate
Sheets("Data").Range("A3").Activate
End Sub
 
Top