I am trying to pull a report that will give me any patron who has attending our Presenting Series (Main stage) shows, but has purchase 3 or more of the events. Whenever I try to run it, it pulls out anyone who has purchased 3 or more TICKETS instead of 3 or more EVENTS. Can anyone help?
Hi Amy -
Did you try using Tickets-Number of Unique Perfs in your criteria? This will give you unique lines in your ticket history. One caveat - if you break out order lines by price type or anything in your ticket history than this criteria will give you inflated (or deflated) numbers.
HTH,
Heather
I will try that! Thanks! I was just so frustrated because it seemed like every way I tried it, I was getting incorrect information...