Hi All!
I am once again trying to wrap my head around a concept, and I hope you all could assist.
What I am looking for is a pivot of all membership renewal amounts for the year. (calendar)
This will include any un-renewed amounts from Jan 1 to today, as well tending amounts for any renewals that are coming up to the end of year.
Thoughts?
I just feel like I am asking 2 different questions and expecting a single answer.
Hi Jen,Thanks for posting! It could be beneficial to cross-post to the Fundraising & Development community group too? Hopefully you'll receive a response over there.- Gill Tasker, Community Manager
Thanks Gill...was just about to do that. :-)
Hi Jen,
In the Memberships data source, could this be Months Membership Expiration Date on Rows filtered by Time frame to This Year. And then values for
Total Next Membership Amount, for renewal amounts in the year.
Total Next Membership Amount
And for un-renewed amounts, ( [Total Membership Amount] , [Renewed Membership Count = 0] )
( [Total Membership Amount] , [Renewed Membership Count = 0] )