topic Re: Cannot figure out why I can't use product or line item as a list filter in Tips, Tricks & Best Practices

Cannot figure out why I can't use product or line item as a list filter

SStewart3 — Thu, 21 Sep 2023 05:50:10 GMT

Hello,
I am not sure what I am doing incorrectly. I have been trying to use my "Medical CME" and "Nursing CEU" products to display on a report and was able to achieve a little success. But I have been unable to used them as a filter for lists so that I can see how many people who registered for an event have paid for that addon. I have been unsuccessful so far. Any tips?

Re: Cannot figure out why I can't use product or line item as a list filter

karstenkoehler — Thu, 21 Sep 2023 05:40:43 GMT

Hi @SStewart3, can you please share a screenshot of your report settings?

Re: Cannot figure out why I can't use product or line item as a list filter

SStewart3 — Thu, 21 Sep 2023 05:46:02 GMT

List settings:

Re: Cannot figure out why I can't use product or line item as a list filter

SStewart3 — Thu, 21 Sep 2023 05:49:14 GMT

I was able to get it to function on this report (why won't it work on the list filters?):

Re: Cannot figure out why I can't use product or line item as a list filter

karstenkoehler — Thu, 21 Sep 2023 05:52:00 GMT

Hi @SStewart3,

In your list, you're filtering for products, not for line items, like in the report. That's likely the reason.

Re: Cannot figure out why I can't use product or line item as a list filter

SStewart3 — Thu, 21 Sep 2023 05:55:26 GMT

I've tried it both ways. 😞

Re: Cannot figure out why I can't use product or line item as a list filter

karstenkoehler — Thu, 21 Sep 2023 05:58:19 GMT

Hi @SStewart3,

Which data sources does your report have?

Re: Cannot figure out why I can't use product or line item as a list filter

SStewart3 — Thu, 21 Sep 2023 06:00:02 GMT

Line items, Payments, and Contacts

Re: Cannot figure out why I can't use product or line item as a list filter

karstenkoehler — Thu, 21 Sep 2023 06:01:35 GMT

Hi @SStewart3,

Your report has a negative filter (is not equal to any of) while your list a positive. Can you double check whether you're using the exact correct product names?

Re: Cannot figure out why I can't use product or line item as a list filter

SStewart3 — Thu, 21 Sep 2023 06:25:47 GMT

Changing the list filter negative now returns results...but they are not the correct results I need. 😭

Re: Cannot figure out why I can't use product or line item as a list filter

karstenkoehler — Thu, 21 Sep 2023 06:30:49 GMT

Hi @SStewart3

Please keep in mind that I only have the context you share with me. For me to be able to help, you need to share more details.

What are you expecting to see, what are you seeing instead? If the filter is the same as on the report, are you seeing the same in both assets? Have you waited long enough for the list to finish populating?