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?
Hi Anne. For Total tickets purchased use "Total Ticket Count" to get the total number of tickets issued. If you search for "ticket count" it comes up.
That's giving me the same numbers as as "total attended count" on every performance, and I know they aren't the same.
Have you tried right clicking on it, and changed sum to count all? That has helped me in a couple of instances.
Or is it possible every ticket for this performance was marked as attended? Are you scanning at the door?