Looking for Dynamic Filter Solution

[nokia6600]

Hello Community Friends,

I have created a PDF document where the table in Alteryx filters based on the employee ID. But the issue is I do not want to show employee who do not have any target for one of the products so my table should filter if someone do not have target for that product. For example, employee 111 do not have Product C target so this should not be in the table when Alteryx generates the report for that particular employee. Thanks all.

Employee	Products Name	Product Sales Target	Actual Product Sales
111	A	500	700
111	B	200	300
111	C
111	D	700	500
222	A	500	700
222	B
222	C	200	300
222	D	700	500
333	A
333	B	500	700
333	C	200	300
333	D	700	500

[AndrewDMerrill · Accepted solution]

Can't you just Filter on NOT IsNull([Product Sales Target])?

More specifics would be very helpful if this is not what you are looking for. Otherwise if my reading/understanding of your request is correct, based on your sample data, nothing would be output because every employee is missing a sales target for at least 1 product.