HI All,
I'm trying to create a value in a pivot table comparing last year's museum attendance to this years museum attendance by month. Either giving me a percentage or a ticket count difference. I feel like there is a formula for this but I have not completely figured out formulas yet. Anyone know how to do this?
I see in formulas there is a growth past year and growth rate but can't get it to produce any numbers for either.
Thank you!
I've not worked this out yet. However, I'd like to figure this out at some point.
If I get something working for this. I'll drop a note here.
Has anyone else sorted this out? This kind of calculation is used in Membership Donations, and Museums a lot. Where our comparables, are from the same period last year.