Pivot Table Drilldown

C

CliffMc

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

Shane Devenshire

Hi,

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

Shane Devenshire

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.
 

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

Keep conditional format when "show pages" from Pivot table 7
Pivot Table Drill down - what does it sort on 1
Top 10 within a drill-down in a pivot table? 8
Help! XL2002 erroneous pivot table fields 1
Drill Down in PivotTables 2
Pivot table pulling wrong value 0
Pivot Table Drill down 2
Drilling into pivot table loses hyperlinks 1

Top