| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate Pivot Table to only 1 Item
I am trying to use the following code to clear all values in a Pivot table
except when it is "Need". However I do not know what may be entered into the originating "Approval" field as several others use this spreadsheet. The results appear in a ListBox and I only want "Need". in the below example "David" may or may not be in the choices of the dropdown. I would like to automate. Any help much appreciated. With Worksheets("Pivots").PivotTables("PivotTable3").Pi votFields("Approval") .PivotItems("David").Visible = False .PivotItems("Dean").Visible = False .PivotItems("Fred").Visible = False .PivotItems("FG").Visible = False .PivotItems("Need").Visible = True End With |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Item in a Pivot Table | Excel Discussion (Misc queries) | |||
| if there an option allow me to appear the item in pivot table as . | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Automate Pivot Table Drill down | Excel Worksheet Functions | |||
| Have a Pivot Table Include a "% of an item" | Excel Worksheet Functions | |||
Threaded Mode
