Hello,
We are trying to set up a pivot table that shows the following (we have the first four working, but the last one is stumping me):
Performance code
Price Type
Total Attended Count
Total Ticket Paid Amount
Total Tickets Purchased
We do a lot of free events, so knowing how many tickets were "purchased" vs. how many actually attended, and at which price type (which is tied to our membership levels, so they get used even for free events) would be very helpful. I've tried adding another value, but everything that seems like it should work is giving me the same numbers as attended. Has anyone else figured this out?
Have you tried using a filter on Total Ticket Count and filtering out your Comp price types?
I haven't. I want to include the comp ticket prices in the total, since for some events all tickets are comp.
Perhaps adding two columns, one filtered and one not, or one filtered to non-comp prices and one filtered to only comp prices might work?