Begin your query:
  1. Navigate to Analysis > Information library
  2. Click Add ad-hoc query
  3. Select source view of Revenue and click OK

Add fields to Include records where:
  1. In the left column, select Application Details. From the middle, drag Designation system record ID into Include records where. Set Not equal to the main designation of the event.
  2. In the Apply Criteria screen, mark "Only return records that do not have a value equal to the selected value," then click OK.
  3. In the left column, expand Application Details and select Event. From the middle, drag Event record into Include records where. Set Equal to your special event.
  4. (Optional) To exclude canceled registrants, in the left column expand Application Details, expand Event, then select Registrants. From the middle, drag Is Canceled into Include records where. Set Equal to No.

Add fields to Results fields to display:
  1. Within a revenue source view, Amount and Date are automatically added to the Results. Unless you need these, you can delete these lines within Results fields to display.
  2. To see the Amount of the registration, not the Amount total (if multiple registrations): In the left column, select Application Details. From the middle, drag Amount into Results fields to display.
  3. To see Registrant name: In the left column, expand Application Details, expand Event, then select Registrants. From the middle, drag Name into Results fields to display.
  4. To see Designation: In the left column, select Application Details. From the middle, drag Designation name into Results fields to display.

Save your query:
  1. Click the Set save options tab
  2. Name your query
  3. Save and Close

Here is an example of your final query:
User-added image