So I am hoping to make something that is both useful internally for tracking and then can be saved to a PDF for show Partners.
Think Box Office Statement - but I have a few things I can't figure out if they are possible.
I have the widget for Capacity, Comp, Attended and Paid pretty much set: with Paid/Reserved for ongoing tracking.
The other part is where I have the question:
Is there a way to get the actual price to report in the breakout by performance? So the math actually works for ticket count x (price) = paid amount??
the request states - Number of Tickets sold at various prices.
And last for the second widget in a dashboard that is many pages how to get it to export to PDF with all the parts.
Thanks TAMATO friends.
Hi Mary,
Try adding either MAX([Ticket Value]) or adding [Ticket Value] in the Rows area after Price Type.
Cheers.
OK - So what if i want the price to be combination of all layers? Fee and Ticket?
Ah, yes. Thanks for asking that. Making sure this is a Value rather than a field on Rows, we can use a formula to get the max total ticket value for any given SLI within each price type + zone combination.
MAX ( [SLI ID] , [Total Ticket Value] )
Here's a shot showing Ticket Value and that formula side by side. The first bit includes Price Layers valued at $33 and $1. Price Layer is then toggled off in the second shot. The MAX Ticket Value then still just shows $33, whereas the formula above yields $34, the max total ticket value for any SLI within the groupings and filters of the pivot table.