Thao you're back! Need help with finding internal values in chart dimensions.

[Hans Riis]

Hi Thao (or anyone else who can be of help).

I have a chart that I switch from date to week on the category axis
via a dropdown menu outside the AxtiveX component. I only want to show
the last XX number of weeks. Instead of trying to calculate values of
the current and previous XX weeks, I'd like to use the internal values
of the axis.

F.ex., in the following code assuming my period starts January 1, 2004

objPFS = ChartSpace1.InternalPivotTable.ActiveView.FieldSets("Week");
objPC = ChartSpace1.InternalPivotTable.Constants;
objPFS.AllIncludeExclude = objPC.plAllInclude;
objPFS.AllIncludeExclude = objPC.plAllExclude;
objPF = objPFS.Fields("Week");

var theDates = Array("200401","200402);
objPF.IncludedMembers = theDates;

gives the same as

var theDates = Array(0,1);
objPF.IncludedMembers = theDates;

How do I find the highest internal value of my week category?
I assume its something like this but it only returns "All week":
test=objPFS.AllMember.Value;

Thanks in advance, Hans Riis

P.S.: Thao, if you're reading this would you please check my two other
recent questions?