Hi there,
I'm in the midst of creating several constituent lists and I'm having trouble finding the right criteria in the List Manager to pull what I need.
Essentially, I'm looking to pull a constituent list with 9 or less tickets in it from a single season, regardless of package/single ticket status.
As of now I've gone through several iterations involving Package Detail, Package History, and Ticket History criteria; the only results I'm getting are either counting the full package rather than the amount of tickets in it, or the number of tickets for each performance in a package rather than the total number of tickets in the order.
Is there a simple criteria I've missed that will simply count up the tickets in an order? Or is there a method involving several criteria that can get that same result?
Any and all help greatly appreciated! Thanks!