I am building a report in Analytics that includes the sum of the budgets in Tessitura for each of the performances in a production season. I am running into an issue where the total only includes budgets for performances that have had sales. Does anyone know a way to include performances with no sales on reports?
Thanks!
I think some people might have ideas, but it's going to be fundamentally hacking. The basic unit of the Seats and Tickets cube is a sub line item: without that you don't have any data to display.
Hacking may include booking & returning a comp for each perf or something that'll give you a line to hang data off.