| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drill down again
is there any solution to iterate through pivotitems and set them
hidden/showed ? imho it seems VERY stupid to have to write code like this to show one item, instead of hiding all and showing what you need, you are provided with ONLY the inverse method :( ActiveSheet.PivotTables("PivotTable1").PivotFields ("[a].[b]").HiddenItemsList = all_but_what_i_need :( |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Drill down to source and update | Excel Discussion (Misc queries) | |||
| Pivot table drill down formatting | Excel Worksheet Functions | |||
| Hyperion Essbase Ad-In - Drill Down Behavior | Excel Discussion (Misc queries) | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| Format Drill to Details Table | Excel Discussion (Misc queries) | |||
Threaded Mode
