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.
Heath, This is SOOO Helpful Thank you so much for the clear instructions and graphics!
That solved my issue and I learned something new
No problem my friend. Birthday treat for me
Good old "Snip & Sketch" and "MS Paint"