Can a Pivot drill down into another pivot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top