Is there a way to pull a list of all the productions we have for a season and the production season values?
I don't see any report that could work and I don't want individual patrons like I would get in the list manager.
I've done it recently in SQL for a structures revue but here is an idea ...... if they have sales how about doing it in analytics? I've attached an attempt and added in a tree diagram as a cool visualization. for the tree diagram you can size and colour code it by ticket count of # customers as well.
It's set for a 2022 Season Fiscal Year but you can do what you like
H
SeasonProductionHeirarchy.dash