How can I limit the number of fields display, when I drill down on a Pivot Table value.
C CliffMc Jan 2, 2009 #1 How can I limit the number of fields display, when I drill down on a Pivot Table value.
S Shane Devenshire Jan 2, 2009 #2 Hi, Excel always outputs all the fields. You will nead to delete the unwanted columns after the drill down.
Hi, Excel always outputs all the fields. You will nead to delete the unwanted columns after the drill down.
S Shane Devenshire Jan 3, 2009 #4 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.
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.
