Filtering on Date Fields in a Pivot Table

J

John

Does Anyone know know how to use FilterMembers on Date
Fields in a PivotTable? In JavaScript:

var v = pivot.ActiveView;
v.ColumnAxis.InsertFieldSet(v.FieldSets("ShipType"));
v.RowAxis.InsertFieldSet(v.FieldSets("InvDate by Month"));
var cf = v.RowAxis.FieldSets(0).Fields
var f1 = v.FieldSets("InvDate by Month").Members
(0).ChildMembers("2004")
cf.FilterMembers = Array(f1)

And fails on this last line. Actually I want to filter on
the Current Month, but was trying this first.

Any advice would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top