List Criteria Trouble

Hello smart Tessiturian minds,

I am stumped.

I am building an extraction and one of the segments I need to find single ticket buyers who have attended for the past 5 consecutive years and have only purchased either  1-2 performances  for each season.

I have for my criteria:

Ticket Seasons in (Fy 08,09,10,11,12)

No of performances<=2

Ticket S or P= S

Ticket Performance Type=Symphony Performances

I have run this a bunch of different ways, and am not getting results anywhere near where they should be. I have no clue where I am going wrong.  Is the Number of performances a total for all seasons combined or is it looking for people who have 1-2  performances per season? Any advice is appreciated!

P.S. This is still V10.

Thanks!

Parents Reply Children
No Data