Filter a PT on a Property via VBA?

[weaverjohn]

Hey Gang:

I need to filter a pivot table based on a field property. Sort of strange, but the database I get the PivotTable data from returns the Week in the accounting month. as the field name. It has several properties which I have figured out how to expose including the period end date. Now I need to figure out how to filter the PT based on that.

The following shows the property:

ActiveSheet.PivotTables("PivotTable4").CubeFields("[Time]").AddMemberPropertyField Property:="[Time].[Week in Month].[End Date]

Now if I just knew how to filter with that value I could move on the the next issue (who knows what opportunities lie ahead to expand my knowledge of VBA )

Thanks

JW

 

[Jerry Sullivan]

Hi JW,

This link might help.
http://www.mrexcel.com/forum/showthread.php?t=565273

Just let me know if you need any help adapting this to your application.

 

[weaverjohn]

Thanks Jerry - I was able to take it from there.