PIVOT TABLES

Special Filter

West + Westhofen, then in your criteria Bereich ="=West"

You will get only WEST

="*o" - treffer will end in o

N?d = one Buchstaben

N*d = mehrere Buchstaben

="=N*rf"

= Norf und Nerf but not Norfen

WERT

#NV

For all values above we assume that there is a criteria Bereich with labels. Now we consider filtering all Fehlerwert.

Above = Kein Uberschrift

Below the criteria is as follows:  =istfehler

=Monat(C6)=8

=und(Monat(C7)=8;Jahr(C7)=2018)