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?
Yep you can bucket levels together a bit like this
Inside each of the "buckets" is a filtered value ( [Total AVC Amount] , [Membership Level] )
Right click on the Membership Level to select the couple of levels you want to sum together.
From there you can bar chart etc.
Heath, this is a GREAT example of bucketing! The best part is the lines with the triangles.
Good old "Snip & Sketch" and "MS Paint"