pivot table filter show all

[Robo0502]

Hi guys,

Pls how can I modify the code below so it will display all options (not just AMAZON and ARGOS) ? I don't want to mention all of them in Array because they may change in future.

Forms![Report]![Pivot_Issue].Form.PivotTable.ActiveView.FilterAxis.FieldSets("End Customer CHM Name").Fields("End Customer CHM Name").IncludedMembers = Array("", "AMAZON", "Argos")

Thank you very much

 

[vbaInet]

This looks like pre Access 2007 pivot table which uses the Office Web Components (OWC) library. Unfortunately I don't have an older version at easy reach but the following should work. Try one of these:

[COLOR="Red"][B]...etc...[/B][/COLOR].FieldSets(" End Customer CHM Name").Fields("End Customer CHM Name").IncludedMembers = Array()

[COLOR="Red"][B]...etc...[/B][/COLOR].FieldSets(" End Customer CHM Name").Fields("End Customer CHM Name").IncludedMembers = Empty

If you want something that will affect the whole Fieldset (and not just one axis) then this:

[COLOR="Red"][B]...etc...[/B][/COLOR].FieldSets(" End Customer CHM Name").AllIncludeExclude = plAllDefault

...By the way the above is shortened code so just append the remaining part to the left. I only made it short for it to be legible.

Welcome to the forum by the way!

 

[Robo0502]

vbaInet, unfortunately first two don't work, but third one is perfect.
Thank you very much for your help.
and for your welcome as well.

 

[vbaInet]

Good to hear!