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.