Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotFilters in pivottable
I have created a pivottable in vba, here is the code for it:
Set pivotCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlExter nal) pivotCache.Connection = Array("OLEDB;Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=My Model 2008;Data Source=mymachine;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error") pivotCache.CommandType = xlCmdCube pivotCache.CommandText = Array("Common Data Model") pivotCache.MakeConnection 'pivotCache.MaintainConnection = True Set pt = pivotCache.CreatePivotTable("Sheet4!R1C1", TableName:="PivotTable1", DefaultVersion:=xlPivotTableVersion12) I add pivotfields in pivottable in the following way: Set cField = pt.cubeFields("[Store].[Store ID]") cField.Orientation = xlRowField but when i try to add a filter to the pivotfield i get an error "Application-defined or object-defined error" This is how I add filters pf1.ClearAllFilters pf1.PivotFilters.Add Type:=xlCaptionEquals, Value1:="0006" Any idea what I am doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Using the PivotFilters function | Excel Programming | |||
Creating a PivotTable w/o selecting data in an existing 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 |