I am trying to make a pivot table where I need to filter the data by the
values in a certain data field ("field 1"). I need to allow records with
either "this or this or this" value in the field 1. The problem is that the
pivot table page filter only allows for one single value to be chosen.

I do not want the field 1 to be shown in the column fields (where it
otherwise would be possible to chose multiple values), since I am not
interested to get the data grouped by the value in field 1 and since I am
also making a pivot chart where the field 1 will blur up the picture.

Any suggestions?