We split our membership program mid fiscal year which resulted in two membership programs to report from.
In a pivot table, or really any chart, can you group rows through some formula or something?
I think you can do this with "bucketing" - its a bit manual to set up as you have to set up all the buckets you want (so if you want 10 rows you have to specify which 10 rows) but once its done it works really well :)
https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/23807/tessitura-analytics-skills-to-the-next-level-webinar---bucketing?_ga=2.248490119.1244946563.1647817927-467708144.1647490002 (part 3)