OWC Pivot table FilterList

[Samp]

H

I have a webpage which has an embedded pivot table component
By default at page load the pivot table is having a activeview wih filter axis having a dimension as a filter criteria
At page load i want to show this filter dropdown as the "All" member unchecked i.e with no filter criteria selected
Is this type of behaviour possible and if yes how

Thanks And Regard
Samp

 

[kiln]

Hi

I have a webpage which has an embedded pivot table component.
By default at page load the pivot table is having a activeview wih filter axis having a dimension as a filter criteria.
At page load i want to show this filter dropdown as the "All" member unchecked i.e with no filter criteria selected.
Is this type of behaviour possible and if yes how?

Thanks And Regards
Samp

It would be interesting to hear about this from MS or someone who knows,
but that is not likely as the OWC is not really supported by Microsoft,
and hardly anyone is intimate with it's poorly documented object,
methods, events, and properties.

But the point you raise is an issue with many filter implementations.
Think about it - if there isn't a filter selection, in a way it
could/should be interpreted as "All", because there is no filter on that
axis. The developers of the OWC seem to have dealt with this by forcing
a selection via the interface. If you notice, the filter list will not
allow you to apply the filter without a selection, either a list item or
the "All" item.