Start your query:
  1. Navigate to Analysis, then click on Information Library
  2. Click on Add an ad-hoc query
  3. Select source view of Memberships, then click OK.

Add fields to Include records where:
  1. Back office transactions: In the left column, expand Membership Transaction, then select Membership Promotion. From the middle column, bring Name into Include records where. Manually type the name of your membership promo and click OK.
  2. Front office transactions: In the left column, expand Membership Transaction, expand Revenue Application, expand Revenue Details, expand Sales Order, expand Sales Order Item, expand Sales Order Item Membership, expand Sales Order Item Membership Item Promotion, and select Membership Promotion. From the middle, bring Name into Include records where. Manually type the name of your membership promotion and click OK.
  3. Click first line for back office transactions in Include records where and click to Add left parenthesis. Click second line item for Front office transactions in Include records where and click the OR button. With second line still selected, click Add right parenthesis.
  4. To see only the primary member in your results, in the left column select Members. From the middle, bring Primary member into Include records where. Set this equal to Yes and click OK. 

Add fields to Results fields to display:
  1. To add details about the constituents in Results fields to display, use fields from the Member\Constituent node. For example, to add name, add Member\Constituent\Name to Results fields to display. 
  2. To add how much the member paid for the membership for front office transactions, in the left column expand Membership Transaction, expand Revenue Application, expand Revenue Details and select Sales Order. From the middle column, drag Amount into Results fields to display.
  3. To add how much the member paid for the membership for back office transactions, in the left column expand Membership Transaction and select Revenue Application. From the middle column, drag Amount into Results fields to display.

Here is an example of what your final query will look like: 
User-added image