Pivot Table Drilldown

  • Thread starter Thread starter CliffMc
  • Start date Start date
C

CliffMc

How can I limit the number of fields display, when I drill down on a Pivot
Table value.
 
Hi,

Excel always outputs all the fields. You will nead to delete the unwanted
columns after the drill down.
 
Hi,

Turn on the recorder and then do the drill down and then delete the unwanted
fields. Turn off the recorded. Test and post the code if there are problems.
 
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

Pivot table drill down data 2
sort order of pivot table drill down 0
Pivot Chart Drill-Down 1
Pivot table filter list - listing irrelevant subcategorys 1
Appending columns or calculation to pivot tables 1
Pivot table - drill down - format 0
How do I sort pivot table data by subtotals? 2
XL2007 - Pivot Table Limitations 2

Back
Top