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!
Hi Kristine,
There a few functions for looking at past period information as you've noticed. Here I have the Date field from the ATTENDED DATE collection, grouping at the Month level. For context, the first two values show the Attended Count in that month, and the Past Year Attended Count showing the Attended Count from that month 1 year prior (note Attended Count in 6/2016=21 and Past Year Attended Count in 6/2017=21). Then the next two columns for Growth and Difference are a percentage and subtraction calculation between the Attended Count and the Past Year Attended Count for a given Attended Date.
CompareLastYearbyMonth.dash
Best,Chris
Chris Wallingford Director, Business Intelligence Tessitura Network office: +1 888.643.5778 x553 chris.wallingford@tessituranetwork.com
What about doing this for comparing an entire fiscal year with the prior fiscal year? The DIFFPASTYEAR function requires that the Pivot be segmented on some sort of date, but "Fiscal Year" is an integer, and that's what I want to segment on. Thanks!
-Galen