Automate Pivot Table Drill down

Automate Pivot Table Drill down

Post by dGlt » Wed, 06 Apr 2005 10:19:05


I would like to automate the drill down of pivot table information, similar
to double clicking on data total. The new sheet name should be equal to the
data field in the pivot table. For example if I had the following pivot

Letter Total
A 10
B 15
C 5
D 25

I would want create four sheets "A", "B", "C", and "D", each with the number
of data rows represented in the Total.


1. Pivot Tables - Drill Down

2. URGENT Drill down in pivot table


can we do drill down or drill through for a pivot table
i'm displaying pivot table on a dashboard screen developed
in the client want to display drill through if
he click on any data.. we are using sql server analysis
manager to connect to the data in the pivot table. I know
how to use drill through in analysis manager but i want to
use the same in pivot table display on the dash board..
if any one knows it plz help me.

Thanks in advance.


3. Pivot Table - Trigger event on drill down

4. How do I change a pivot table report to sort when I drill down

5. Pivot Table Drill Down

6. Pivot Table - Simultaneous Drill-Down

7. Custom Roll up and Drill down calculation for Excel Pivot table

8. Pivot Table drill down and 256 character limit

9. Pivot Table drill downs

10. Pivot table drill down formatting

11. Pivot table "drill down to data"

12. Top 10 within a drill-down in a pivot table?

13. Drill down pivot table data via VBA macro

14. Macro to Format the Pivot Table drill down

15. how to see complete memo field in pivot table drill down detail