Multiple criterias in a Pivot filter

Hi (Excel 2010)

In my pivottable I have a list of names.

Now I want to show only the rows with names including "ete" or "eve". I can set up af filter for each, but how do I filter for both of them.

Furthermore I would like to show the rows with "Johnsson" Is there a way to do it.

Something like : Select * from names where (names like %ete% or names like %eve%) and names like %Johnsson%

Example:

NAMES

John Adams (Not to to be shown) Peter Grandjean (To be shown) Eric Hansen (Not to be shown) Evelyn Bond (To be shown)

Regards

Peter

hi Peter,

Set Pi = ActiveSheet.PivotTables(1).PivotFields(1) On Error Resume Next For Each p In Pi.PivotItems If p.Visible = False Then p.Visible = True Next

For Each p In Pi.PivotItems If p Like "eve" Or p Like "ete" Or p Like "Johnsson" Then p.Visible = True Else p.Visible = False Next

-- isabelle