I am trying to filter a pivot table field using Label Filter

Copper Contributor

I would like to filter using Contains with multiple values such as red, green or blue. I have tired various separators but once i add the second word i get no values returned. I have tried comma, semicolon, a colon and a space. Each attempt returns no results after the second condition is added.

1 Reply

@Chrislbf 

That doesn't work such way, it shall be only one condition. There are workarounds like this https://superuser.com/questions/896831/multiple-label-filters-in-a-pivot-table