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 |
Solved! Go to 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.