Pivot Table filters with OR operator

[limalf]

Hi!

I have been looking for a solution to filter a pivot table that contains these 3 column fields: User 1, User 2, and User 3.

However, when I want to see the results for "John" in all those fields, I need to use one filter at a time. Is there any other way to see all results of the Pivot Table where "John" is a User, no matter if he is the 1, 2 or 3 user?

Thank you in advance.

[limalf]

Hi,

Sorry if I am not posting in the right section, but this is part of the solution of the previous problem.

I decided to build 3 pivot tables, one for each user, and filter them with the same criteria. The results will be used to hide or show the results of the main table.

However, I am having problems with the code. Can you please have a look to see what I am doing wrong?

Please Login or Register  to view this content.

[Izandol]

You have mistyped Pivotfields.

[limalf]

Thanks so much Izandol! what a mistake...