How do you select new values on the dropdown of the PivotTable so they are displayed on your chart?

[Douglas Osborne]

All,

The cube I build gets one day added to it each day. I have the XML report
saved as YTDAll.xml.

I load the YTDAll.xml file, it sets the data member and returns all of the
data.

However, the 'new' day is unselected in the pivot table - is there a way to
select the 'all' button so all days are checked off? or do I need to hit it
twice to toggle it so all are selected?

I know this is kinda vague, so any help is appreciated.

Doug

 

[Douglas Osborne]

The field in the pivot table is

frm1.PivotTable1.ActiveView.FieldSets(9).Caption = 'VisitDay';

Is it something off of
frm1.PivotTable1.ActiveView.FieldSets(9).Allmember.View?

Doug