Dashboard Goal: For all you General Admission users
Show Per Cap (admission revenue vs attendance) monthly and begin tracking it year over year.
I'm sure I can find all the revenue and attendance data, but I am not sure how to make the formula work. Any advice here would be helpful.
Bryan
bryan.kowert@nascarhall.com
Hi Bryan,
You can try dividing by [unique # Constituent ID], which if you're grouping by Season Fiscal Year or the event date Fiscal Year, will divide by the unique count of constituent records behind the revenue and attendance within each year.