Heath kindly sent me a work-around for this but it doesn't seem to work on my end. I am trying to include in my pivot table the specific capacity for each concert (it is different for each concert bc of stage extensions and production black outs), the number of seats available for sale, and the number of seats in hold codes. Season Manager seems to have it, so I should be able at access these numbers somehow. Anyone have a solution other than writing complex formulas?
Thanks,
Michael
Can you share what you've got for the pivot right now? That might help us look at what's not working for you.
HI Michael - what Maery said. If you share your dash we can have a look at the formulas. Also note that in v15.1.5 Analytics handes Holds very differently and will requires a little formula tweaking.
Thanks for this, Michael! I think that you should look at the value "Seat Unsold Count", which should get you the total available seats (unless you're using the Suppress Unsold keyword on your performances, as I just discovered we apparently are?). From there, I think a filtered value like (SUM(Total Unsold Seat Count), Seat Hold Code) should get you to where you need to be with Held/Open -- though I'm not current on the intricacies of how hold codes are handled in the various versions.