Filtering Problem

[Razorbx13]

Hello, I am trying to filter a table that lets me filter on a field but show all the records related to another field.  In the example below where all the data comes from one table.  I would like to be able to filter on a MANAGER but show all the EMPLOYEE records in which the MANAGER filter was part of.  In the example below, right now if I setup regular Manager filter and filter by PICARD I will be returned two rows.  What I want to happen is when I select PICARD I want to show all the records of the EMPLOYEE in which PICARD was at least one of.  So, in the below example, if I filtered for PICARD I want to see all records for SMITH and KIRK.  If I selecte RYKER I would be returned all records for all three employees.  Can anyone help?

Thanks!

Employee	Client	Manager	Hours
Smith	A	Picard	2.00
	B	Ryker	23.00
	C	Data	5.00
	D	Sundance	6.00
	E	Seven of Nine	7.50
Jones	F	Janeway	6.90
	G	Gorn	6.30
	H	Ryker	5.70
	I	Tuvok	5.10
	J	Data	4.50
Kirk	K	Worf	3.90
	L	Picard	3.30
	M	Ryker	2.70
	N	Janeway	2.10
	O	Spock	1.50

[ThxAlot]

Hrs.pbix