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.
ok something still isn't right - the math doesn't add up: $124.5 x 475 does not equal $35,722.00 andI pulled for paid/reserved too.
Ideal result -
1- base price (all price levels)
2- paid price (all price levels)
3- sold count
4- total paid amount
is the Price Per Ticket a Max Value at the Price per ticket? What's your ATP for those rows?
I was just checking your initial table 2019-10-25(E)PG102519E Zone 1 Single Ticket has 42 tickets at $4875. Is there dynamic pricing in there? Are you missing a Price Layer? Are some Pricetypes editable?
price per ticket is- MAX ( [SLI ID] , [Total Ticket Paid Value] )
base is MAX( [SLI ID] , [Total Seat Home Base Value] )
dynamic pricing yes. All layers are showing. Prices are editable.
Correct me if I'm wrong but MAX ( [SLI ID] , [Total Ticket Paid Value] ) will give you the most expensive Ticket Price for that Price type over all zones (ie: Premium). Your Zone 4 Single tickets are about $45 yeah? So your ATP for Single Tickets on Friday would be around $74.57I just had a crack at Chris' formula and for our subs ranging from $38.25 to $83.30 it's just returning the top price of $83.30
Hi,
Breaking by Zone is necessary in order to get a distribution of Price Type values, rather than just the MAX across all zones. Zone was in Mary’s original post screen shot, so I neglected mentioning that specifically. As Heath mentioned, taking Paid Amount will be impacted by editable and dynamic pricing. It will be a Max Paid Amount in that Price Type + Zone combination. You could switch that MAX to AVG if thats more aligned with you goal measure within each PT+Z. If you’d rather see the initial prices you’ve SET for the PT+Z, try Ticket Home Value...or Ticket Value for current prices.