1. Navigate to Analysis>Information library
  2. Click on Add an ad-hoc query
  3. Select source view Sales Orders and click OK
  4. In the left column select Sales Orders. From the middle, drag Order complete date to Include records where. Set equal to your date range, such as this calendar year.
  5. Drag this same field into Results fields to display
  6. In the left column, select Sales Orders. From the middle, drag Refund Status text into Include records where. Set equal to Not Refunded 
  7. In the left column expand Sales Order Item, then expand Sales order Item Ticket, then select Program. From the middle, drag Program Record into Include records where. Set equal to your Daily Admission program.
  8. In the left column select Sales Orders Item. Drag Total to Include records where. Click the blue Sigma symbol and select SUM. 
    • NOTE: If you want to see the amount less discounts, use the Net Amount field
  9. Click on Lookup ID in Results fields to display and select the red X to delete line item.
Your final query should look similar to below:
User-added image