Hello All,
Happy Wednesday to you.
I have a reporting puzzle to work out. We used a pricing event to increase prices about a month in to the on-sale after an early bird period. This is causing the "performance revenue gain-loss" report to be not great in looking at results of actual dynamic pricing that have occurred closer to each performance. Is there some way to filter or show a detail of pricing events?
Thanks,
Kanani
Hi there! I'm trying to build similar dahsboard for one of our events but I'm a bit stuck as our event has 2 price layers (a ticket layer + a VAT layer) which means that the 'Ticket Paid Amounts' are split into ticket 'prices' and VAT 'prices' which makes it very confusing. Does anyone know if there is a way to show the full amount? Thanks!
Hi Leonor,
You could apply a filter to the widget on Price Layer Category and limit the results to only Ticket Price layers. Rename that [Ticket Paid Amount] on Rows to [Ticket Price Amount]. Then add a value for Ticket Price that is the total price including VAT for that Ticket Price:
MAX ( [SLI ID] , ( SUM ( [Ticket Paid Amount] ) , ALL ( [Price Layer Category] ) ) )
And another value for the Ticket Paid Amount that includes VAT
SUM ( [SLI ID] , ( SUM ( [Ticket Paid Amount] ) , ALL ( [Price Layer Category] ) ) )
Then if you'd like, to hide the Ticket Layer Amount column, rename it to just "." a period and change the formatting to be a number with 0 decimals. Then shrink the column width as much as it will allow.