​The Zip Code Report cannot be grouped or filtered by price type, but we can use a sales order query to gather this information.
  1. From Analysis, choose Information library.
  2. Add an ad-hoc query, and select the record view of Sales Order.
  3. If looking for a particular time frame, select Order complete date in the middle column, and drag it to Include Records where. Set it equal to or between your date range.
  4. If you are only looking for certain zip codes, from the middle column, drag ZIP to the Include records section, and set it equal to, between, or one of and put in the ZIP codes you wish to include. 
  5. To see ticket sales from certain programs, expand Sales Order Item in the left column. 
  6. Next, expand Sales Order Item Ticket, and highlight Program.
  7. From the middle column, drag Program record to Include records where, and set to equal to your program choice. You can also choose "one of" if you are looking to see multiple programs.
  8. From the middle column, drag ZIP to the Include records section, and set it equal to, between, or one of and put in the ZIP codes you wish to include. 
  9. Now, we'll add items to the Results fields to display to tell Altru what information you'd like to see about the records above.
  10. In the Results fields to display area, highlight Lookup ID, and click the Red X above to remove the field. 
  11. From the middle column, drag ZIP to Results fields to display.
  12. In the left column, highlight Sales Order Item. 
  13. Drag Quantity from the middle column to Results fields to display to see the quantity of tickets sold. 
  14. In the left column, expand Sales Order Item, then expand Sales Order Item ticket.
  15. In the middle, select Price Type Code and move to Results Fields to Display.
  16. Click Preview results to see the results.
  17. Go to the Set save options tab.
  18. Name and Save and Close the query.