Sales by Ticket Price

I should be more clear...I want the price map cost. The base price of the ticket without any fees.

I should be more clear...I want the price map cost. The base price of the ticket without any fees.

Hi Gloria,

Check out Solution 155 on TASK.
We use this report often and it sounds like what you are looking for.

Here is some of the description:

For the given parameters this report will produce a list of the number of customers,
tickets and cash as well as percentages for each price type.

The parameters allow you to select Seasons, Productions, Performances, Performance
Dates, Order Dates or a List.

Just making sure I understand what you're after:

You want something that essentially says "X tickets at $Y, Z tickets at $Q" etc. regardless of which price types may have been used? You want it organized by the amt due on the ticket, not the price map itself. Is that correct?

Yes, that's right. By the due_amt in the sub_lineitem. I wrote a  query but it would be nice to have a report if someone already created one.

Thanks Ryan. I did set up this report. The problem is that it includes fees added to the ticket price.

That's odd...mine doesn't include any fees.
I may have customized it but I don't remember doing so.