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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Pivot Chart Drill-Down 1
Pivot Chart Data labels 1
Pivot Table Resutls Don't Match the Graph 2
how to persist pivot chart data 1
Pivot table drill down data 2
Pivot table drill down sort 0
Issues when pivot charts are refreshed and pivots has filters 1

Back
Top