Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing pivot table views with a macro
I want to create a macro that lets you change the arrangement of a pivot
table in Excel 2003 with OLAP Data. I turn on the macro recorder and make the changes to the pivot table manually then I see the results but is very complicated and do not work at all. Is there a simple way to add one item and remove another item? Or to do a do while cycle or for each cycle of all items and then select the items that I'm interested to show. Those are very complicated: Hoja.PivotTables("PivotTable").CubeFields(3).Treev iewControl.Drilled Hoja.PivotTables("PivotTable").PivotFields("[Fecha].[Year]").HiddenItemsList The thing I need to do is to show the past 12 months of a date dimension for a given date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Customized Views | Excel Discussion (Misc queries) | |||
changing pivot table views with a macro | Excel Programming | |||
Custom Views in Pivot Table | Excel Discussion (Misc queries) | |||
Changing field in Pivot Table with macro | Excel Programming | |||
macro, pivot table and changing number of rows | Excel Programming |