I am working on recreating one of our custom reports and there are two things I am having trouble with....
1. Our report sorts by production with the next production appearing first and past performances moving to the bottom. Is this possible in Tessitura Analytics?
2. We also do a percent of the budget so we can keep an eye on how close each show is to making budget. I am not sure how to go about this in analytics as I cannot do a formula on a row. I also cant figure out how to total the budget by production since the amount is added to each performance.
Any help would be greatly appreciated.
Thanks
Margaret