How would I go about finding those who have an order in each season for the past X number of seasons? Any help or insight is greatly appreciated!
Hi Michael,
A raw start might be to filter on the past X number of Season Fiscal Year, and in a Pivot with Constituent ID on rows have a value for [# unique Season Fiscal Year], with which you could then filter the value to only results that equal X.
That gives me the numbers I need! Now, I can use those numbers and find out what share of our ticket inventory they account for in each of those years. Thanks for the fast response!