Pivot Table

[tbrynard01]

I have a column that I want to filter on in a pivot table. The column contains multiple values in some cells, how do I filter out only words that contain certain cell ranges:

For example these are all values in the cells and I only want to see the rows that contain HART for example?

Thank you any help will be appreciated!


[TABLE="width: 299"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Line 1 Column A

MHP Visit (Client Requested), MMPI Administration, HART Initiation, Coordination of Care[/TD]
[/TR]
[TR]
[TD][TABLE="width: 299"]
<colgroup><col></colgroup><tbody>[TR]
[TD]
Line 2 Column A

[/TD]
[/TR]
</tbody>[/TABLE]
BPS and MHSF-III

Line 3 Column A[/TD]
[/TR]
[TR]
[TD]HART Initiation, MMPI Interpretation

Line 4 Column A[/TD]
[/TR]
[TR]
[TD]Case Consultation / Update (Staff Requested)[/TD]
[/TR]
[TR]
[TD]Line 5 Column A
Psychological Testing, Risk Assessment[/TD]
[/TR]
</tbody>[/TABLE]

 

[tbrynard01]

Thanks you too, you prompted me in the direction I was lacking