Hi Anne -
Rather than use the Advanced Criteria section to filter information out, under Data, go to Filter Report Data instead.
This will allow you to submit the criteria that you need for each separate field:
In your example, you can allow for the event start dates as well as select which regions to include or exclude from your report.
In case you don't see the field that you want to filter off of, you may need to click the pencil in the top right corner and toggle that field on, in order to use it on your filters.
Hope this helps!
------------------------------
Rebecca Yousif
Senior Administrator - Event Technology
------------------------------
Original Message:
Sent: 08-14-2024 16:02
From: Anne Carey
Subject: Cross Event Report - Complicated Advanced Criteria
My report is pulled from the MRF, so date needs to be "Any." I used Advanced Criteria to limit start and end dates to include all 2024 events.
I also need to filter out any events that are not in the USA, however some events have that field blank. I need those included in my report. I can't see a way to use "or" in this section. The other section needs to be set to "All," not "Any," however there doesn't seem to be a way to separate the two sections.
I'm missing about 125 events in my report. Can anyone help?
#Reporting
------------------------------
Carey (my nickname)
Anne Carey
Manager, Compliance
For: Boehringer Ingelheim GmbH
------------------------------