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?
As far as I know you can do it, if awkwardly, by adding formulas on the values. So you'd create filtered Revenue values for "Revenue - Benefactor", "Revenue - Leader", etc.