Our Marketing team would like to know how many customers were "grandfathered" in last year and what zone they were in and the price per ticket vs price of standard price ticket.
I cannot get this data from an output set, been trying. Does anyone know a canned report or reports that could get me the data?
EX
ID Name Package Name Price Type zone Price per ticket price of standard ticket
1 Cust A Pops7 Grandfather A Dress Circle 45.00 48.00
2 Cust B Classic12 Grandfather B Orchestra 48.00 48.00
That way they can analyze the gains and losses of stopping this program.
I don't have sql experience so I cannot go in the back end and pull it. Any ideas? Deadline is here.