Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable
Hi
I want to hide all item in a pivotfield , but not the first one. Now I use this code, but it takes a lot of time to loop (4000 items). Can I do it in a other way, to do it faster? With ActiveSheet.PivotTables("PivotTable1").PivotFields ("PRODNO") For I = 2 To .PivotItems.Count .PivotItems(I).Visible = False Next I End With Regards // Lasse |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable
If you only want to show one product why not just drag the Prod No off of the
table and include it in the header? In the header you can just select the first item. HTH "Lasse Matsson" wrote: Hi I want to hide all item in a pivotfield , but not the first one. Now I use this code, but it takes a lot of time to loop (4000 items). Can I do it in a other way, to do it faster? With ActiveSheet.PivotTables("PivotTable1").PivotFields ("PRODNO") For I = 2 To .PivotItems.Count .PivotItems(I).Visible = False Next I End With Regards // Lasse |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Pivottable | Excel Discussion (Misc queries) | |||
How does one get the PivotTable report info that feeds another PivotTable report? | Excel Programming | |||
PivotTable - PivotTable Field name is not valid - error! | Excel Programming | |||
Creating a PivotTable Report from an Another PivotTable Report | Excel Programming |