Can a Pivot drill down into another pivot
 

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


Dineshnewcommer wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html