| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PIVOT - refresh pivot based on Field / item
Hiii,
I have a pivot table with 4 rowitems, 2column headings, 2 datas row item 1 North row item 2 South row item 3 East row item 4 West col heading 1 Jul09 revenue col heading 2 aug09 revenue Row field name = "Region" contents = North, South, East & West the table is placed in the range of a7 : a200 I allow to enter in b2 as North and allow to enter in b3 as Delhi Now i want VB code to filter fields/items North & Delhi as above Eddy Stan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PIVOT - refresh pivot based on Field / item
you can use the worhsheet Data/Filter/AutoFilter for this
"Eddy Stan" wrote: Hiii, I have a pivot table with 4 rowitems, 2column headings, 2 datas row item 1 North row item 2 South row item 3 East row item 4 West col heading 1 Jul09 revenue col heading 2 aug09 revenue Row field name = "Region" contents = North, South, East & West the table is placed in the range of a7 : a200 I allow to enter in b2 as North and allow to enter in b3 as Delhi Now i want VB code to filter fields/items North & Delhi as above Eddy Stan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change a pivot field based on another pivot field | Excel Programming | |||
| Pivot Table refresh and calculated item disabled | Excel Discussion (Misc queries) | |||
| Pivot field dropping one item | Excel Discussion (Misc queries) | |||
| Calculated Field/Item in a Pivot | Excel Worksheet Functions | |||
| determine cell is part of pivot item or pivot field | Excel Programming | |||
Linear Mode
