Begin your query:
  1. Navigate to Analysis, then click on Information library
  2. Click Add an ad-hoc query
  3. Select source view of Sales Orders and click OK

Add fields to Include records where:
  1. In the left column, expand Sales Order Item, expand Sales Order Item Membership, then select Sales Order Item Membership Add on. In the middle column, drag Name into Include records where. Manually type name of Add On and click OK.

Add fields to Results fields to display:
  1. In the left column, select Constituent. From the middle, drag Name into Results fields to display
  2. In the left column, expand Sales Order Item, expand Sales Order Item Membership, then select Sales Order Item Membership Add on. From the middle column, drag Name into Results.
  3. From the same middle column, drag Total Price into Results fields to display.
  4. To see transaction date: In the left column, select Sales Orders. From the middle column, drag Transaction date into Results fields to display.

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

We can view the following video for assistance querying on Member add-ons sold through sales: