E
Etienne
Hi, I'm trying to filter the serie field of a PivotChart.
I succeeded in filtering it with the following code:
Me.Form.ChartSpace.Charts
(0).SeriesCollection.PivotAxis.fields
(field).IncludedMembers = filterArray
where filterArray contain only the fields I want... But
now I want to be able to just get rid of this filter. But
if I do (...).IncludedMembers = Empty, it include nothing
and in the documentation it says it's suppose to clear the
filter (so display everything back again)...
The obvious solution would be to include all the members
in filterArray, but it's not really good performance
wise...
Anyone have an idea?
I succeeded in filtering it with the following code:
Me.Form.ChartSpace.Charts
(0).SeriesCollection.PivotAxis.fields
(field).IncludedMembers = filterArray
where filterArray contain only the fields I want... But
now I want to be able to just get rid of this filter. But
if I do (...).IncludedMembers = Empty, it include nothing
and in the documentation it says it's suppose to clear the
filter (so display everything back again)...
The obvious solution would be to include all the members
in filterArray, but it's not really good performance
wise...
Anyone have an idea?