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]

 

[sandy666]

Label Filters - Contains - HART

 

[tbrynard01]

Thank you. Not sure where I would put that. "Label Filters - Contains - HART" I don't know Pivot tables very well. Thanks.

I use a PC and Office 365.

 

[sandy666]

 

[tbrynard01]

I apologize not sure if the reply was intentionally left blank. I know how to create a pivot table and have the filter but don't know how to tell it to filter only rows that contains HART. I can't see where I can put the criteria. In a regular filter I can put contains HART but I don't see the option in the Pivot. Thanks

 

[sandy666]

you didn't see the picture ? this is a .jpg so you should see

https://postimg.cc/cKQqyNWr

or

example video

or

post link to shared excel file with representative example via OneDrive, GoogleDrive or any similar

 

[tbrynard01]

Thank you. Trying to send you my pivot but the site is restricted here at my work. The column Restricted services where the text HART would be is a filter in my pivot the Rows are Client Names, Columns are Assigned and it's not giving me the option to select label filters.

 

[tbrynard01]

Thank you, figured it out

 

[sandy666]

something like this ?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#FFFF00]SOURCE[/td][td][/td][td][/td][td=bgcolor:#FFFF00]PIVOT[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Client[/td][td]Restricted[/td][td][/td][td=bgcolor:#DDEBF7]Client[/td][td=bgcolor:#DDEBF7]Restricted[/td][/tr]

[tr=bgcolor:#FFFFFF][td]aa[/td][td]a HART[/td][td][/td][td]aa[/td][td]a HART[/td][/tr]

[tr=bgcolor:#FFFFFF][td]bb[/td][td]vfr[/td][td][/td][td]bb[/td][td]vfr[/td][/tr]

[tr=bgcolor:#FFFFFF][td]cc[/td][td]xxHART ggg[/td][td][/td][td]cc[/td][td]xxHART ggg[/td][/tr]
[/table]

result

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Client[/td][td=bgcolor:#DDEBF7]Restricted[/td][/tr]

[tr=bgcolor:#FFFFFF][td]aa[/td][td]a HART[/td][/tr]

[tr=bgcolor:#FFFFFF][td]cc[/td][td]xxHART ggg[/td][/tr]
[/table]

 

[sandy666]

Thank you, figured it out

good to see that, it wasn't so hard, isn't it ?

have a nice day