| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Drilldown
How can I limit the number of fields display, when I drill down on a Pivot
Table value. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Drilldown
Hi,
Excel always outputs all the fields. You will nead to delete the unwanted columns after the drill down. -- If this helps, please click the Yes button Cheers, Shane Devenshire "CliffMc" wrote: How can I limit the number of fields display, when I drill down on a Pivot Table value. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Drilldown
Would anyone have some VBA that would do that for me?
"Shane Devenshire" wrote: Hi, Excel always outputs all the fields. You will nead to delete the unwanted columns after the drill down. -- If this helps, please click the Yes button Cheers, Shane Devenshire "CliffMc" wrote: How can I limit the number of fields display, when I drill down on a Pivot Table value. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Drilldown
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "CliffMc" wrote: Would anyone have some VBA that would do that for me? "Shane Devenshire" wrote: Hi, Excel always outputs all the fields. You will nead to delete the unwanted columns after the drill down. -- If this helps, please click the Yes button Cheers, Shane Devenshire "CliffMc" wrote: How can I limit the number of fields display, when I drill down on a Pivot Table value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I remove old items in a drilldown box in a pivot table? | Excel Discussion (Misc queries) | |||
| DRILLDOWN on a Pie Chart | Excel Discussion (Misc queries) | |||
| Pivot Chart Drilldown | Charts and Charting in Excel | |||
| pivot drilldown | Excel Discussion (Misc queries) | |||
| Pivot table drilldown | Excel Worksheet Functions | |||
Linear Mode
