Filter from a field where the data is separated by comas

[dohanians]

I want to create a pivot table but the data in the column that I want to use as a filter is separated by comas in the same column. Can I choose to filter only by a part of the text somehow?

Example:
Column: Papers
Value: ABS, CMO, DMW

I want to filter only the records that contain ABS in the field. Is that possible?

[mo4391]

In the Field List of your pivot table, under where it says "Choose fields to add to report:", click the drop down arrow on Papers.
Select "Label Filter" -->"Contains", then type the value (in this case ABS) into the field.